Below The below steps should be followed to get the WIQL query in an ADO search.
...
3. Run the ADO query '▶️ '.
...
4. Go to the network section.
...
7. Expand the options until you find the WIQL, as shown in the image below.8.
...
Copy the WIQL line.
...
For example, the query would be like this:
Code Block SELECT [System.Id],[System.WorkItemType],[System.Title],[System.AssignedTo],[System.State],[System.Tags] FROM WorkItemLinks WHERE ([Source].[System.TeamProject] = @project AND [Source].[System.WorkItemType] <> '') AND ([System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward') AND ([Target].[System.TeamProject] = @project) ORDER BY [System.Id] mode(MustContain)
The query to be added to the TFS4JIRA filter
...
should be adjusted, without the
WHERE
...
,
ORDER BY
andSystem.TeamProject
keywords. In our example, the correct query to add would be:Code Block
...
[Source].[System.WorkItemType] <> '') AND ([System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward')
...
That’s because that part of the query is already filled used the configurations made during the mapping process:
...
Note |
---|
Be aware that not all functions work in the TFS4JIRA filter, so this query could help in case |
you need to obtain field names and the correct way to use |
them. For example, the
|