It's all about the answers!

Ask a question

Can widget list pending reviews by reviewer?


Tim Fuller (471125) | asked Jan 21 '16, 11:50 a.m.
We'd like to have a work item statistics widget that lists pending reviews by reviewer. But reviewer (also approver, validater) is not available as the sort parameter.  Any ideas on how this could be accomplished?

The Pending Approvals by Me works for individuals, but we'd like to have a list by name so project managers can see who needs "encouragement" to complete their reviews.

Using 5.0.1



Comments
Tim Fuller commented Jan 21 '16, 12:46 p.m.

Addition:  We'd like to be able to show only the overdue reviews that are pending.

One answer



permanent link
Don Yang (7.2k2194128) | answered Jan 21 '16, 7:42 p.m.
Hi, Tim

I don't know if a custom report(RRDI etc) can do the job or not. JRS does not seem to be able to achieve what you want in v5.x.

The closest query is what you may know "Pending Approval" query. If you copy this query and add condition of due date(approval descriptors > due date), it will show those pending approval workitems related to due date you set. In the query, you can add "Approval" to column so that approval related info will display in this column. The problem is that the name of approver(s) is not a part of the info showing up, only name of Approval when creating because RTC does not currently support adding approver as an attribute to query's column. To workaround this, you may want to give the approver's name to Approval name field when you "add approval" and input the name on the field.
(the same applies to reviewer's name in Review name field when Adding Review").

Also if you have multiple approvers or reviewers, you may want o Add Approval or Add Review multiple times so that each approver or reviewer will have a field to input the name and it will show up in the query.



 

Comments
Don Yang commented Jan 27 '16, 7:02 p.m.

Your answer


Register or to post your answer.