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. |
Accepted answer
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
|