Hi,
I have been trying to write an Odata query that collects all the "Initiative" work items from mulitple projects within one Azure DevOps Organisation. However, some of the projects in the organisation does not have "Initiative" work items (not in the template of the project).
My query:
$select=WorkItemId,Title,ActivatedDate,Area,ClosedDate,CreatedDate,Iteration,ParentWorkItemId,Priority,StartDate,State,StateCategory,Tags,TargetDate,ValueArea,WorkItemType,Project
&$filter=
Project/ProjectName eq '{project_that_contains_initiative_work_items}'
& Project/ProjectName eq '{project_that_contains_initiative_work_items}'
& WorkItemType eq 'Initiative'
&$expand=Iteration,Area,Tags,Project
This query seems to return work items of other types, but none of the "Initiative" type.
I have checked that I can collect initiative work items if I create a query for each project, but would prefer not to as there are quite a few projects to query from. I have also checked that the query works if I am query for other work items of another type (a type that exists in all projects).
Thank you!
