Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Query for Multiple Approvals

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?

1

0 votes

Comments

 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 log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 201

Question asked: Aug 23 '12, 1:22 p.m.

Question was seen: 4,578 times

Last updated: Jan 26 '13, 2:58 p.m.

Confirmation Cancel Confirm