Jira Query Language (JQL) is a powerful query language used in Jira to search and filter issues. Here’s a cheat sheet with some commonly used JQL queries and operators:
Basic Queries
Search by Issue Key:
issueKey = "PROJECT-123"Search by Summary:
summary ~ "keyword"Search by Reporter:
reporter = currentUser()Search by Assignee:
assignee = "username"Search by Status:
status = "In Progress"Search by Project:
project = "Project Name"Advanced Queries
Search by Issue Type:
issuetype = BugSearch by Priority:
priority = HighSearch by Labels:
labels in ("label1", "label2")Search by Epic Link:
"Epic Link" = "Epic-123"Date and Time Queries
Search by Due Date:
due < "2024-01-31"Search by Created Date:
created >= "2024-01-01" AND created <= "2024-01-31"Combining Conditions
Logical AND:
project = "Project Name" AND assignee = currentUser()Logical OR:
status = "In Progress" OR status = "To Do"Order and Limit Results
Order by Priority:
ORDER BY priority DESCLimit Results:
project = "Project Name" ORDER BY created DESC MAXRESULTS 10Special Keywords
Current User:
assignee = currentUser()Empty Field:
field is EMPTYSubqueries
Subquery for Issues in Epic:
"Epic Link" = "Epic-123"Subquery for Issues in Sprint:
Sprint = "Sprint Name"Saved Filters
Saved Filter:
filter = "My Saved Filter"Notes
- JQL is case-sensitive.
- Use double quotes for exact string matching.
- Dates should be in the format “yyyy-MM-dd.”
This cheat sheet provides a quick reference for Jira Query Language. JQL is a versatile language, and you can create complex queries by combining different conditions and operators. For more details, refer to the official Jira Query Language (JQL) documentation.