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

How to find out of a task in RTC has approval/review created?

We want to create a query in RTC that will list all the task for which no approval/review created. How this can be achieved in RTC?
I know that once we have an approval/review created, we can have a query to see the task based on their approval status but in our case we would like to see all those task for which no approval/review was created at all.

0 votes


Accepted answer

Permanent link
I did not find any obvious 'does not contain approvals' condition that can be added to a work item query to do this, but I did figure out that there is one way to get the query you want:

-Type is 'Task'
   AND
-Approvals > State is not:
    [x] Approved
    [x] Pending
    [x] Rejected

I.e if  work item does not have 'any' of the valid states, then it must not have an approval.
Michael Valenta selected this answer as the correct answer

1 vote

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,014
× 201

Question asked: May 24 '16, 12:16 p.m.

Question was seen: 4,155 times

Last updated: May 24 '16, 8:07 p.m.

Confirmation Cancel Confirm