Question

Forms report with start time and end time for each User Task in Forms process.

Forms

Updated October 10, 2023

asked on October 4, 2023 • Show version history

I currently have a report that I email out to a participant user not on my domain that shows the start date/time, and end date/time along with a few other fields. If I log in to Forms and I can click on individual processes then drill down into a process and see start and end for each User Task that had happened.

I would like to have a custom report in Excel where I could get the start and end to calculate duration of each User Task. It looks like the table [cf_bp_main_instances] has the time for the process but I haven't found a table for individual tasks.

Forms user task start date and end date.jpg (55.76 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on October 9, 2023

You can use table [cf_bp_worker_instance_history] to find start time and finish time for individual steps.

For example,

SELECT *
FROM [$DB].[dbo].[cf_bp_worker_instance_history]
WHERE 
instance_id = (SELECT instance_id FROM cf_bp_worker_instances WHERE bp_instance_id = $BP_INSTANCE_ID)
AND
step_id = 
(SELECT step_id FROM [cf_bp_steps] WHERE process_id=(SELECT process_id FROM cf_bp_main_instances WHERE bp_instance_id = $BP_INSTANCE_ID) and step_type='userTask')

replacing '$DB' with your database, '$BP_INSTANCE_ID' with your bp_instance_id.

0 0

Replies

replied on October 10, 2023

Thank you. I think I may need to make a few changes but this got me the info I needed.

0 0

You are not allowed to follow up in this post.

Question

Question

Forms report with start time and end time for each User Task in Forms process.

Answer

Replies

Sign in to reply to this post.