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

Query work items not approved by anyone

Questions
Tags
Users
Badges
mark byrd
(147●1●23●30) Feb 11 '13, 10:42 a.m.
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
Millard Ellingsworth
FORUM ADMINISTRATOR / JAZZ DEVELOPER Feb 11 '13, 6:21 p.m.
Do you mean items that carry no approvals at all? Or the case where all approvals are pending approvals (neither rejected nor approved yet)? 

mark byrd
Feb 12 '13, 7:42 a.m.
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)". 

mark byrd
Feb 13 '13, 9:39 a.m.
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? 

1 answer
6,927 views
0 votes

One answer

Permanent link
Millard Ellingsworth
FORUM ADMINISTRATOR / JAZZ DEVELOPER (2.5k●1●24●31) Feb 12 '13, 1:04 p.m.
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
mark byrd
Feb 13 '13, 8:06 a.m.
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.

Ask a question
Guidelines
FAQ
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,146

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

Question was seen: 6,927 times

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

Confirmation Cancel Confirm