query work items based on change set contributors
I am trying to create a query that shows Work Items that have change sets that I delivered as related artifacts. I tried to create the query based on Modified By > My user ID, but that does not yield any results.
A similar query, which uses Owned By > My user ID works fine, but it identifies only a subset of the change sets I'm wanting to find because I have contributed change sets to work items that are not owned by me. How can I identify all Work Items that are associated with change sets delivered by me or any contributor of interest?
Accepted answer
There are no query terms in a work item query for change set information, so you cannot create such a query.
The Modified-By and Owned-By properties are properties of the work item itself, and are not related to change set information (such as who associated the change set to the work item) in any way.
On a terminological note, I'd recommend not using the term "deliver" when talking about invoking "Related_Artifacts -> Associate_Work_Items" operation. The "deliver" operation adds change sets to a stream, and does not associate a change set with a work item.
The Modified-By and Owned-By properties are properties of the work item itself, and are not related to change set information (such as who associated the change set to the work item) in any way.
On a terminological note, I'd recommend not using the term "deliver" when talking about invoking "Related_Artifacts -> Associate_Work_Items" operation. The "deliver" operation adds change sets to a stream, and does not associate a change set with a work item.
Comments
I edited my question to reflect your terminological note. Let me know if it's still semantically sloppy.
Yes, this fixes it ... many thanks for taking the trouble to do the edits! It makes the forum a much more effective resource when the questions are clearly stated.
No problem. I cut my teeth on StackOverflow so I'm aware of the benefits of editing questions for clarity. Do you know how I can submit this as a feature request?