TFS4JIRA | How to Obtain WIQL from Azure DevOps query

Owned by Adriana Hernandez
Last updated: Mar 06, 2024 by Gabriela Costa
2 min read

The 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, as shown in the image below.

  1. 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)

  2. The query to be added to the TFS4JIRA filter should be adjusted, without the WHERE, ORDER BY and System.TeamProject keywords. In our example, the correct query to add would be:

    [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:

 

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 [System.Links.LinkType] does not work in the TFS4JIRA filter.

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