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