Retrieving Change Task Assignee and Reviewer using Query Builder
‎Jan 13, 2011
04:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Jan 13, 2011
04:56 PM
Retrieving Change Task Assignee and Reviewer using Query Builder
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>
Thanks,
John Frankovich
GSI Group LLC
www.gsiag.com<">http://www.gsiag.com>
Labels:
- Labels:
-
Other
4 REPLIES 4
‎Jan 13, 2011
05:00 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Jan 13, 2011
05:00 PM
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:
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:
‎Jan 14, 2011
06:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Jan 14, 2011
06:58 PM
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>
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>
‎Jan 14, 2011
07:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Jan 14, 2011
07:54 PM
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]
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]
‎Jan 14, 2011
11:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Jan 14, 2011
11:27 PM
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
John
Sent from my Palm Pre on AT&T