JIRA Query Language (JQL)
JQL stands for JIRA Query Language and is not to be confused with Java Query Language. It’s the most flexible way to search for issues in JIRA. Another benefit? JQL is for everyone: developers, testers, project managers, as well as business users.
There are basically three part in JQL:
Field – target search like projects, epic, issue
Operator – comparision to be done
Value – what it should compare with? Eg name of project etc
Source – atlassian.com
How to write JIRA Query?
- From the menu bar choose Issues > Search for Issues
- If you do not see the bar where you can type JQL commands then click Advanced.
- Next, in the text box you can start writing JQL commands. You may press enter or click search button
- If you click example filters on the left pane like Reported by me, My open issues etc then you will see builtin query that will be automatically typed in the command bar.
Other useful JQL commands
To find unassigned issues:
assignee is EMPTY order by creator ASC
To find all issue assigned to you:
assignee=<your jira name>
To find tickets of project ABC with status done and ordered by created date
project = ABC and status = Done ORDER BY createdDate
To find tickets of project ABC with status = complete
project = ABC and status = “Code Complete”
To show all issues updated today
updatedDate >= startOfDay()