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

[dsolat]

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.

[MatthewKnight]

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?

[dsolat]

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

[MatthewKnight · Accepted solution]

Criteria, WfActivity.KEY == WfDataEventAudit.ACTIVITY_KEY.

[dsolat]

Thanks a lot . I have used the criteria as specified by you, and getting the vote in report.