JQL stands for Jira Query Language. While it is not a database query language, is has some similarities to SQL syntax. JQL is used to create advanced searches in Jira.

The Jira/Grow integration has one custom report available called “Issue Search.” While a single report may seem limited, JQL makes it actually very dynamic. Once you select the report, a box will pull up where you can write JQL. The initial query in the box is: project = "ProjectName" AND assignee = currentuser()

A basic query consists of three parts: a field, an operator, and then one or more values or functions.

A simple query might be the following: project = “TEST”
This would find all of the issues in the project called TEST.

Here’s another example, using the initial query in the box. The project is called Grow Test 1.
project = “Grow Test 1” AND assignee = currentuser() 

This would return all of the issues that are assigned to the person who is currently signed in to Jira.

Using these fields, keywords, and operators, you have the potential to build much more complex queries. 

You can also use the following help documents Jira provides on writing JQL:

 You can also read Jira’s documentation here. This article gives a similar overview of JQL.

Below are some examples of some queries using JQL.

Example 1:
JQL Query: (project = "Technology" OR project = "Executive"OR project = "Sales and Marketing") AND issueType = Bug AND status != "Done" AND created >= -30d 

Example 2:
JQL Query: createdDate >= {{date('start of year','YYYY-MM-DD')}} AND resolutionDate IS NOT NULL 

Example 3:
JQL Query: createdDate >= {{date('start of month','YYYY-MM-DD')}}  

Questions about JQL? Email us at support@grow.com or chat in on the site.

Did this answer your question?