How to find next activity performer in workflow through dql?

Question

Hello,

i have a problem to find who is the next manual activity performer in started workflow through dql.

I found all finished activities in the table dmi_workitem, but not the next activity performer.

Also, in dm_workflow, I can find the last performer, but not the next one.

For exemple, I have Activity1 and Activity2. The performer in the Activity1 select the performer in Activity2, without using process variables. So, I want to know which performer is the choosen in Activity1, after it is finished.

Please help me. It is urgent.

Regards

lazo983 · Accepted Answer

Hi Jørg,

thank you for your reply and help, but I found solution to my problem. Actualy, I used Split decision with Activity1 and DQL Read, and because both of this activities are created, I find who is the performer of the Activity1 with this DQL:

Select user_group_name,user_address,user_name from dm_user where user_name in (select name from dmi_queue_item where router_id='workflow_id' and task_name='Activity1')  ENABLE (ROW_BASED, RETURN_TOP 1)

where workflow_id is the id of the running workflow.

Regards