Workflow delegation report

(0) Share

Report

Posted on by Community Member

Hi,

I need to report on Workflow delegation. When we setup a workflow delegation for a user, we are entering a reference number in the Comment section. But when I look at the tables I cannot find how to link the two tables.

From the user options > Workflow tab > Delegation. Enter delegate, dates... Then in the comment section, enter the reference number.

The 2 tables used are WorkflowWorkItemDelegationParameters and WorkflowWorkItemCommentTable. The comment id is available in the delegation table, but it is not available in the work item comment table.

Do you have any idea, how I could link the information to report on the workflow delegation including the comment?

Thanks for your help.

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi Violaine,

You can use recid to link two tables.

And the commentid is associated with ID field in WorkflowWorkItemCommentTable.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks MatGuo,

But what do you mean by the commentid is associated with ID field?

Was this reply helpful? Yes No
Verified answer

MATTGUO 22,349 Moderator on at

Like (0)

Report

Hi,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks a lot for your help.

I used the Chrome Table browser to look at the table and here is what I have, hence my question.

Was this reply helpful? Yes No