Using JQL to Filter Issues

JQL, or Jira Query Language, is a powerful and flexible way to search for your issues in Jira and can also help you filter important issues right into your roadmap.

When to use JQL

When setting up your Jira integration in Strategic Roadmaps, there are two ways to filter down which issues from a project should be pulled into your roadmap.

Basic

Basic mode allows you to filter issues by Type (Task, Story, Bug, Epic) and by Status (To Do, In Progress, Done) by simply multi-selecting the appropriate values. If you need to use other fields as criteria, then you’ll need to use JQL.

Open

JQL

JQL mode allows you to specify the JQL query that Strategic Roadmaps should use to filter incoming issues from your Jira project. 

Configuring Strategic Roadmaps to use JQL

Open

1. Select the Jira Project you want to bring into Strategic Roadmaps from the Project dropdown. 

2. Toggle the Configuration Mode from Basic to JQL. 

3. Input your query in the Custom JQL text field. 

4. Click the Validate button to ensure that your query is correct.

5. If "Everything looks good!" then press Next.

Troubleshooting Tips

The most common causes of errors in Custom JQL are:

An Invalid Query

This could be anything from a typo to trying to access a field or value by the wrong name. Before entering JQL into Strategic Roadmaps, we recommend using the Advanced Search feature in Jira to build the exact JQL query you'd like to use. Then, simply copy and paste your query into the Custom JQL field in Strategic Roadmaps.

Your Query Specifies a Project or Has an "Order By" Clause

As these specific values are selected when the integration is setup, Strategic Roadmaps will always prepend your project ID and append an order by clause to your JQL query. You'll need to exclude these from your JQL when you copy it over from Jira to ensure that the query is read successfully. 

Strategic Roadmaps placement within the full JQL query is shown below: