Common Jira Query Language (JQL) Queries
JQL is a powerful language used in Jira to filter, search, and organize issues. Below are some everyday JQL queries you can use to streamline your workflow.
1. Find all issues assigned to a specific user
assignee = jdoe
Finds all issues assigned to jdoe.
2. Find all open issues in a specific project
project = "My Project" AND status in ("To Do", "In Progress")
Shows all issues in My Project that are either To Do or In Progress.
3. Find issues that are due today
due = startOfDay()
Finds all issues that are due today.
4. Find all issues created in the last 7 days
created >= -7d
Finds issues that were created within the last 7 days.
5. Find all issues with a specific priority (e.g., High)
priority = High
Filters all issues that are marked with High priority.
6. Find all issues of a specific type (e.g., Bug)
issuetype = Bug
Shows all Bug type issues.
7. Find unresolved issues assigned to a user
assignee = jdoe AND resolution = Unresolved
Shows all unresolved issues assigned to jdoe.
8. Find issues with a specific label
labels = "UI-issue"
Filters issues with the label UI-issue.
9. Find issues that have not been updated in the last 2 weeks
updated <= -2w
Finds issues that haven't been updated in the last 2 weeks.
10. Find issues linked to a specific issue
issue in linkedIssues("PROJ-123", "blocks")
Shows issues that are blocked by PROJ-123.
11. Find all issues due in the next 7 days
due <= 7d
Filters issues that are due within the next 7 days.
12. Find all issues that are assigned to no one
assignee IS EMPTY
Shows all unassigned issues.
13. Find issues updated by a specific user
updatedBy = jdoe
Filters issues that were last updated by jdoe.
14. Find issues with a specific Epic Link
"Epic Link" = "EPIC-123"
Filters issues that are part of the Epic EPIC-123.
15. Find unresolved issues assigned to a specific person
assignee = jdoe AND resolution = Unresolved
Shows unresolved issues assigned to jdoe.
16. Find issues with a specific status transition (e.g., from "To Do" to "In Progress")
status CHANGED FROM "To Do" TO "In Progress"
Finds issues that transitioned from "To Do" to "In Progress".
17. Find issues created in a specific time period (e.g., last month)
created >= startOfMonth(-1) AND created <= endOfMonth(-1)
Filters issues created in last month.
18. Find issues where the summary contains specific text
summary ~ "login"
Finds issues with "login" mentioned in the summary.
19. Find issues in a project that are either "To Do" or "In Progress"
project = "My Project" AND status IN ("To Do", "In Progress")
Filters issues in My Project that are either "To Do" or "In Progress".
20. Using Wildcards
summary ~ "bug*"
Asterisk (*): This is a wildcard character used for matching patterns. Finds issues with summaries that start with "bug".
21. Parent-Child Relationship
parent = "PROJ-123"
Finds subtasks of the issue PROJ-123.
22. Issues with specific link types
issue in linkedIssues("PROJ-456", "blocks")
Finds issues that block PROJ-456.
23. Worklog queries
worklogAuthor = jdoe
Finds issues where jdoe logged time.
24. Time spent
timespent > 3600
Finds issues where more than one hour (3600 seconds) has been logged.
25. Custom Field Queries
cf[10001] = "Custom Field Value"
Finds issues where the custom field with ID 10001 has the value "Custom Field Value".
Resources for Learning More
- Atlassian JQL Documentation
- Practice with the JQL Search Bar in Jira itself.
- Explore examples on community forums or your team's best practices.