TFS4JIRA | How to Obtain WIQL from Azure DevOps query

Below steps should be followed to get the WIQL query in an ADO search.

1. Prepare the WIQL on the ADO.

2. Click on Inspect the current page.

3. Run the ADO query '▶️ '.

4. Go to the network section.

5. Click on the query line.

6. Go to the payload.

7. Expand the options until you find the WIQL.

8. Copy the WIQL line.

for example, the query would be like this:

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)

1. The query to be added to the TFS4JIRA filter will be without the WHERE and ORDER BY keywords.

([Source].[System.TeamProject] = @project AND [Source].[System.WorkItemType] <> '') AND ([System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward') AND ([Target].[System.TeamProject] = @project)

Be aware that not all functions work in the TFS4JIRA filter so this query could help in case needed to obtain field names and the correct way to use it.

For example the [System.Links.LinkType] does not work in the TFS4JIRA filter.

[System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward'