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

Where

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

  1. Choose a field such as status or assignee, an operator, and type a value. For in and not in, separate the values with commas.
  2. Add more conditions and join them with AND or OR.
  3. Pick a sort field and direction for ORDER BY.
  4. Read the plain-words line under the query to confirm it says what you mean.
  5. 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

OperatorMeaningExample
= and !=Equals, does not equalstatus = Done
~ and !~Contains, does not contain (text fields)summary ~ login
in and not inMatches any value in a listpriority in (High, Highest)
> >= < <=Compare dates and numberscreated >= "-7d"
is EMPTY and is not EMPTYThe field has no value, or has oneassignee 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.

Sources

More free tools

All free tools