Query to find approvals I am NOT a part of.
I can not figure out how to create a query to find the existing approvals where I am NOT an approver. I am already narrowing the search by date and custom workitem type. Now I want to know which of these does not list me as an approver.
I thought I could use the Approvals>Approver>Name>does not contain
option and specify my name. That works fine if I'm the only approver. The workitem is ignored. But when a second approver is listed along with my name, the query finds the workitem even though I said "Does NOT contain". I assume this check is looking at each approver entry and if any approver does not contain my name it is considered a match and adds it to the output.
Does anyone have an idea how I can create this query.
Thanks, Doug
I thought I could use the Approvals>Approver>Name>does not contain
option and specify my name. That works fine if I'm the only approver. The workitem is ignored. But when a second approver is listed along with my name, the query finds the workitem even though I said "Does NOT contain". I assume this check is looking at each approver entry and if any approver does not contain my name it is considered a match and adds it to the output.
Does anyone have an idea how I can create this query.
Thanks, Doug
One answer
I can not figure out how to create a query to find the existing
approvals where I am NOT an approver. I am already narrowing the
search by date and custom workitem type. Now I want to know which of
these does not list me as an approver.
I thought I could use the Approvals>Approver>Name>does not
contain
option and specify my name. That works fine if I'm the only approver.
The workitem is ignored. But when a second approver is listed along
with my name, the query finds the workitem even though I said
"Does NOT contain". I assume this check is looking at each
approver entry and if any approver does not contain my name it is
considered a match and adds it to the output.
Does anyone have an idea how I can create this query.
The underlying query model currently doesn't support this type of query.
--
Regards,
Patrick
RTC Work Item Component Lead