Skip to main content
1-Visitor
May 6, 2013
Solved

How to get the assignment activity vote in querry builder report.

  • May 6, 2013
  • 4 replies
  • 2688 views

Hi,

i have created a report using query builder to get all the activities of PR, the owner of the activity, the time when activity was assigned, the time when the activity was completed and the time taken for each activity to be completed. I also want to get the vote of the activity in this report but not able to get it, i have got the table in which the vote are stored i.e wf voting event audit. the tables used by me for this report are- wf assigned activity, work item and problem report table. Please help in how i can include the vote of the task in the report, the required joins for it.

Best answer by MatthewKnight

Criteria, WfActivity.KEY == WfDataEventAudit.ACTIVITY_KEY.

4 replies

1-Visitor
May 6, 2013

WfVotingEventAudit.EVENT_LIST

You're lucky that EVENT_LIST is a String. It's not a pretty attribute, but maybe you can use an xsl to format the results?

dsolat1-VisitorAuthor
1-Visitor
May 7, 2013

Which joins are required for this. Can you please provide the joins required for wf voting event audit table.

1-Visitor
May 7, 2013

Criteria, WfActivity.KEY == WfDataEventAudit.ACTIVITY_KEY.