Finding Milestones per Attributes of their Artifacts' Parents

[Michael Strong]

Trying to find Milestones that have artifacts that role up to a particular Top-Level Portfolio Item.

 

Logically, it would be something like this:

 

((Artifacts.Parent.FormattedID = <<ID>>) OR

 (Artifacts.Parent.Parent.FormattedID = <<ID>>))

 

This is not acceptable syntax, and I've not found what I seek after some online searching.

 

How would we form the query to achieve this objective?

 

Thanks, in advance.  Mike

[David LeDeaux]

Hi Mike,

 

I think the issue here is that Artifact level.  It's a very primitive form of a work item if you look at the object model and Parent does not exist at this level yet.  If we are browsing Artifact objects in the API, they do get "hydrated" with their inherited attributes based on their work item type, but as for querying the API, we're stuck at that primitive level. [Artifact]

 

I'm not sure that this is possible with a single query.  It might be necessary to do this programatically and break it out into two requests.