It's all about the answers!

Ask a question

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

Rohit Rishabh (1531236) | asked May 24 '16, 12:16 p.m.
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.

Accepted answer

permanent link
David Lafreniere (4.8k7) | answered May 24 '16, 8:07 p.m.
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'
-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

Your answer

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.