JQL query builder and examples
Pick a field, an operator and a value for each condition and the tool writes the JQL for you, with quoting handled, then explains it in plain words. Load any of 14 common queries, such as my open issues or stale issues, and change the values.
Everything runs in your browser. Your text and files stay on your device and are never uploaded.
Build a query
Your JQL
ORDER BY created DESC
Finds every issue you can see. Sorted by created, highest or newest first.
Row 1 is left out until it has a value.
A bare name like yourcompany becomes yourcompany.atlassian.net. Leave it empty to get a link with a placeholder site.
Common JQL queries
Copy one, or load it into the builder and change the values.
My open issues
Everything assigned to you that is not done, newest update first.
assignee = currentUser() AND resolution is EMPTY ORDER BY updated DESC
Unassigned open issues
Work nobody owns yet, a good triage list.
assignee is EMPTY AND statusCategory != Done ORDER BY created DESC
Created in the last 7 days
Everything filed this past week.
created >= "-7d" ORDER BY created DESC
Open and not touched in 30 days
Stale issues to close or revive.
statusCategory != Done AND updated <= "-30d" ORDER BY updated ASC
Overdue issues
Past the due date and still open.
due < now() AND resolution is EMPTY ORDER BY due ASC
Due this week
Open issues with a due date before the end of this week.
due <= endOfWeek() AND due >= startOfWeek() AND resolution is EMPTY ORDER BY due ASC
Current sprint, not done
What is left in the sprint that is running now.
sprint in (openSprints()) AND statusCategory != Done ORDER BY priority DESC
High priority open bugs
Bugs marked High or Highest that are still open.
issuetype = Bug AND priority in (High, Highest) AND resolution is EMPTY ORDER BY priority DESC
Resolved this month
Issues closed since the first of the month.
resolved >= startOfMonth() ORDER BY resolved DESC
Issues with no labels
Find work that skipped labelling.
labels is EMPTY AND resolution is EMPTY ORDER BY created DESC
Reported by me and still open
Issues you filed that have not been resolved.
reporter = currentUser() AND resolution is EMPTY ORDER BY created DESC
Text search in summary or description
Replace the word with your own search term.
summary ~ login OR description ~ login ORDER BY updated DESC
Open stories with no epic
Stories not grouped under an epic. Jira Cloud links stories to epics through parent; on Data Center use "epic link" instead.
issuetype = Story AND parent is EMPTY AND resolution is EMPTY ORDER BY created DESC
Open issues in a release
Change the version to the release you track.
fixVersion = "2.1" AND resolution is EMPTY ORDER BY priority DESC
How to use it
- Choose a field such as status or assignee, an operator, and type a value. For in and not in, separate the values with commas.
- Add more conditions and join them with AND or OR.
- Pick a sort field and direction for ORDER BY.
- Read the plain-words line under the query to confirm it says what you mean.
- Copy the JQL, or the search link, and paste it into Jira's advanced issue search or a dashboard filter.
JQL operators in plain words
| Operator | Meaning | Example |
|---|---|---|
= and != | Equals, does not equal | status = Done |
~ and !~ | Contains, does not contain (text fields) | summary ~ login |
in and not in | Matches any value in a list | priority in (High, Highest) |
> >= < <= | Compare dates and numbers | created >= "-7d" |
is EMPTY and is not EMPTY | The field has no value, or has one | assignee is EMPTY |
Useful functions: currentUser() is whoever runs the search, openSprints() is every sprint running now, startOfWeek() and endOfMonth() give calendar edges, and "-7d", "-2w" mean seven days and two weeks ago while "2w" means two weeks from now. Relative dates take w, d, h or m (minutes).
Questions
What is JQL?
JQL, the Jira Query Language, is the text syntax Jira uses for advanced issue search, filters, boards and dashboard gadgets. A query is one or more conditions like status = Done joined by AND or OR, with an optional ORDER BY.
When do values need quotes in JQL?
Quote any value with a space, a reserved character such as a dot, or a reserved word such as start or user, so In Progress becomes "In Progress" and version 2.1 becomes "2.1". Atlassian also asks for quotes around relative dates like "-7d". Functions like currentUser(), whole numbers, issue keys and single plain words stay bare. The builder applies these rules for you.
Why does my query with AND and OR return the wrong issues?
JQL reads AND before OR, so a OR b AND c means a OR (b AND c). The builder warns when you mix them. Add parentheses in the query when you want a different grouping.
How do I write a date relative to today in JQL?
Use a number and a unit in quotes: "-7d" is seven days ago, "2w" or "+2w" is two weeks from now, and the units are w, d, h and m for minutes. For calendar edges use functions such as startOfWeek(), endOfMonth() or startOfWeek(-1) for the start of last week.
Where do I paste the query?
In Jira, open Filters and go to the advanced search (called issue search or work item search, depending on your site), switch from Basic to JQL and paste. The same text works in saved filters, board filters, dashboard gadgets and automation rule conditions.
Does this tool connect to my Jira?
No. It only writes text in your browser, so it cannot check that a status or project exists on your site. Field and value names must match what your Jira uses.