cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

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

dsolat
1-Newbie

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
MatthewKnight
4-Participant
(To:dsolat)

Criteria, WfActivity.KEY == WfDataEventAudit.ACTIVITY_KEY.

View solution in original post

4 REPLIES 4
MatthewKnight
4-Participant
(To:dsolat)

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?

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

MatthewKnight
4-Participant
(To:dsolat)

Criteria, WfActivity.KEY == WfDataEventAudit.ACTIVITY_KEY.

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

Top Tags