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

Query work items not approved by anyone

I know how to query work items rejected by anyone, pending by anyone, or approved by anyone. Is there a way to query work items not approved by anyone?

0 votes

Comments

Do you mean items that carry no approvals at all? Or the case where all approvals are pending approvals (neither rejected nor approved yet)? 

I mean a situation where I've customized operation behavior to require approvals for code delivery, where I require a work item to be approved by 1 person that's been assigned the approval role. A developer will request approval from multiple people with the approval role.  I want to query and find work items where no one has approved the work item. I guess that could also be stated as "where all approvals are pending approvals (neither rejected nor approved yet)". 

I notice that the "quick Information" section of a work item has an approval's approved, rejected, pending counts. Can a query access that info? 



One answer

Permanent link
Did you look at the query condition "Approval Descriptors"? One of the options is Cumulative State.

I just created a simple query that looks for Approval Descriptors > Cumulative State is Pending and it found a work item to which I had added an approval (that had not been processed). It did not return items that had no approvals nor items that were approved or rejected. It did return items that had multiple approval where at least one was Pending.

Is this what you are looking for?

0 votes

Comments

Thanks for responding. I've tried "Approval Descriptors" but still did not get what I needed.  Excluding an item with no approvals is good, but I need to also exclude an item if any of it's approvals are approved, as long as none of its approvals are rejected.

Your answer

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

Question asked: Feb 11 '13, 10:42 a.m.

Question was seen: 4,708 times

Last updated: Feb 13 '13, 9:39 a.m.

Confirmation Cancel Confirm