Retrieving Change Task Assignee and Reviewer using Query Builder

[jfrankovich]

Does anyone know how to get the Assignee and Reviewer for a Change Task using Query Builder? We want to generate a report of all change tasks that are Under Review along with the name of the task's Reviewer. This would seem easy, but we haven't found the correct attribute/table to retrieve the Reviewer or even the Assignee. Any help is appreciated.

Thanks,
John Frankovich
GSI Group LLC
www.gsiag.com<">http://www.gsiag.com>

[AL_ANDERSON]

If you are trying to find out "who has what on their worklists" then look
for workitems joined to WfAssignedActivities.

You can also join the workitem to WfProcess, and even WTPart or WTDocument
or WTChangeRequest2, or whatever (depending on what the primary business
object is going to be), as well as User, Team Template (if you want that,
then join Team Template to the WfProcess), etc.

You can filter by the task name more easily than the role name.

You can also make a criteria on the primary business objects lifecycle
state, if that helps.

I can send you an example if this doesn't get you in the right direction.

Al Anderson





John Frankovich <->
01/13/2011 12:56 PM
Please respond to
John Frankovich <->


To
"-" <->
cc

Subject
[solutions] - Retrieving Change Task Assignee and Reviewer using Query
Builder




Caterpillar: Confidential Green Retain Until: 02/12/2011



Does anyone know how to get the Assignee and Reviewer for a Change Task
using Query Builder? We want to generate a report of all change tasks that
are Under Review along with the name of the task?s Reviewer. This would
seem easy, but we haven?t found the correct attribute/table to retrieve
the Reviewer or even the Assignee. Any help is appreciated.

Thanks,
John Frankovich
GSI Group LLC
www.gsiag.com


Site Links: View post online View mailing list online Send new post
via email Unsubscribe from this mailing list Manage your subscription
Use of this email content is governed by the terms of service at:

[jfrankovich]

Much thanks to Al, Steve, and Mike. The Work Item table wt.workflow.work.WorkItem was the key to getting the Assignee and Reviewer (Work Item.Ownership.Owner.Full Name) for tasks.

Now our report shows which tasks are stuck in Review, who has it, and how long they have been holding it.

Thanks again,
John Frankovich
GSI Group LLC
www.gsiag.com<">http://www.gsiag.com>

[MikeLockwood]

Be careful here on one thing...

Work Items are temporary - the system delete them (default is 100 at a time, controlled by a preference). They are perfect for reporting work in process but cannot be reported on after completion.

[cid:image001.png@01CBB403.44252E20]

[cid:image002.png@01CBB403.44252E20]

[jfrankovich]

Thanks for the tip. In this case the work item is perfect because we are only reporting on incomplete items.

John



Sent from my Palm Pre on AT&T