It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,882
×12,008

question asked: Mar 19 '14, 10:09 a.m.
question was seen: 3,929 times
last updated: Mar 19 '14, 11:27 a.m.

Related questions

How can I query all work items that have the same owner and approval?

0
S S (14●14●18) | asked Mar 19 '14, 10:09 a.m.
Is this programmatically possible?  i.e. I want to find all work items that have Bob as the both the Owner and the Approver of a work item.

Accepted answer

0
permanent link
Piotr Aniola (3.7k●1●17●38) | answered Mar 19 '14, 10:43 a.m.
It's possible to do "return all workitems where owner = 'Bob' and approver = 'Bob'.
It's not possible to do "return all workitems where owner = approver".
If the latter use case is the desired one, I suggest to create a custom report that returns such workitems.
S S selected this answer as the correct answer
Comments
S S commented Mar 19 '14, 11:21 a.m.

Yup, was looking for the latter case. Is there anyway to get a resulting column from a query with the name of the approver listed? I.e. query on all work items for any owner but have RTC return the owner for each work item.

sam detweiler commented Mar 19 '14, 11:27 a.m.

sadly, no.. approval data is not displayable/exportable. 

One other answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
sam detweiler (12.5k●6●195●201) | answered Mar 19 '14, 10:36 a.m.
 seems pretty straight forward.. if you are looking for 'Bob'

if you are looking for cases where the two userids are identical.. then I don't think you can do that in the query editor.

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.