query builder: can I specify that the value of 1 attribute is the same as another attribute?
I don't believe this is possible, but I thought I would ask before opening an enhancement:
Is it possible to create a query that lists Defect work items types where there is no Verification approval for the creator?
I was thinking it would be something like this in the query builder:
Type = Defect
where
ApprovalDescriptors > Type is Verification
and
Created By IS NOT Approvals > Approver
Right now, I can use Created By is "Joe" and Approvals>Approver is not "Joe" but I either have to:
1) use "current user" and tell all 300 people to run it
2) create 300 queries (1 for each person)
3) create a query that takes parameters for those two people, run it 300 times, and make sure that I pick the same person for both parameters.
Susan
Is it possible to create a query that lists Defect work items types where there is no Verification approval for the creator?
I was thinking it would be something like this in the query builder:
Type = Defect
where
ApprovalDescriptors > Type is Verification
and
Created By IS NOT Approvals > Approver
Right now, I can use Created By is "Joe" and Approvals>Approver is not "Joe" but I either have to:
1) use "current user" and tell all 300 people to run it
2) create 300 queries (1 for each person)
3) create a query that takes parameters for those two people, run it 300 times, and make sure that I pick the same person for both parameters.
Susan
2 answers
Hi Susan,
You need not create queries for each user, instead -> you can use "currentUser" as the variable type while creating queries via the process configuration.
Are you creating queries via the process config?
Thanks.