In the query builder report, how to get an assigne name (in a role) from a workflow?

[dfrancisco]

In the query builder report, how to get an assigne name (in a role) from a workflow?

For example, I want to list the Project leaders from each workflow, linked, of course, to a documet.

[Marco_Tosin · Accepted solution]

Daniel,

take a look at this article I wrote Resource for reporting

There are many query builder report already done.

Maybe you can find something useful for you.

Marco

[dfrancisco]

Hello Marco

After some time, trying to find a wat in the link that you sent to me, I found a tip that guided me to my answer.

Thanks

[Marco_Tosin]

Daniel,

even if redundant, maybe you can add exact answer for other users in this discussion.

[dfrancisco]

Great Marcos, You're right.

If someone is trying to do same, follow these instructions:

1. Selecting in "From" according picture:

Note: In my case the target workflow is "Desenvolvimento Alteração Produto". Select the yours.

2. In "Join":

3. Now in "Select" you need to set your choice, and remind to use "User.Full Name" and "Work Item.Role" to show the responsible for a task in the workflow:

4. Another good tip is, in "Criteria" create a condition according bellow to show only open tasks:

It is all!