Delegated task

Question

Hi all,

i need your opinions about DQL, for this problem:

I need to get which task is delegated, from who, to who in a workflow.

I tried this DQL

SELECT *

FROM dm_audittrail_s

where event_source='workflow' and workflow_id='id'

It gives me huge number of rows. How to get the ones I need? Which column is the one I need?

Thank you in advance.

lazo983 · Accepted Answer

I found it. I used this DQL query:

SELECT *

FROM dm_audittrail_s

where event_source='dm_delegatedworkitem' and workflow_id='id'

where user_name is the one who delegated the task and string_5 is to who is delegated.