It's all about the answers!

Ask a question

Query for Multiple Approvals

Robert Carter (42928589) | asked Aug 23 '12, 1:22 p.m.
I have work Items the require multiple 'Levels' of Approvals.  For instance, Dev Team, then PMO, Then Executive.  I want to create a query that shows work items in these buckets based on approval status.  So, I create three approvals, One for DevTem One For PMO and then One for Executive.  Here's the fun part.

Query All Work Items Pending DevTeam Approvals (Works)
Approval Descriptors>Name IS 'DevTeam' AND Approval Descriptors>Cumulative State IS pending

Query All Work Items Pending PMO Approvals (Does Not Work)
This query should only report the PMO Approvals is Pending AND DevTeam Approvals is Approved
(Approval Descriptors>Name IS 'DevTeam' AND Approval Descriptors>Cumulative State IS Approved)
AND (Approval Descriptiors>Name IS 'PMO' AND Approval Descriptors>Cumulative State IS pending)

If we just reuse the first query and change the DevTeam to PMO it does not give use what we want.  The PMO team does not want to see pending approvals until the DevTeam approves the work item.  This happens because the three approvals are added when the work item is created.

I believe the workaround could be only add the Approvals after each team completes their approvals.  Trying to avoid that workaround.

Any Suggestions?

Pavithra Kasturirangan commented Jan 24 '13, 2:03 a.m. | edited Jan 26 '13, 2:58 p.m.

 Hi Robert,

This seems interesting. Were you able to get any solution for your requirement ?

Be the first one to answer this question!

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.