Jira search cheatsheet

Jira provides an advanced search option where users can create a search query using the Jira Query Language (JQL). JQL has some similarities to SQL in its syntax. Once you have a search query that you like, you can save it up as a filter.

Here are some common ways to search for JIRA issues:

• Issues with certain text in their title or description:

text ~ "foobar"

• Issues belonging to a certain project:

project = FOOBAR

• Issues created by me:

reporter = currentUser() ORDER BY created DESC

• Issues viewed recently:

issuekey in issueHistory() ORDER BY lastViewed DESC

• Issues updated recently:

issuekey in issueHistory() ORDER BY updated DESC

• Issues of an epic:

"epic link" = FOOBAR-1422

• Issues that are children of another issue:

issuekey in childIssuesOf("XYZ-2005")

• Issues that are linked to a given issue:

issuekey in linkedIssues("XYZ-2005")

• Check if issue is or is not of a certain type:

issuetype == Task
issuetype != Task

• Issues with a certain fixVersion:

fixVersion = 10.0

• Issues without a fixVersion:

fixVersion = EMPTY

• Multiple criteria can be ANDed or ORed:

"epic link" = FOOBAR-1422 OR "epic link" = FOOBAR-2344

• Order the filtered issues by one or more keys:

reporter = currentUser() ORDER BY status ASC, priority DESC, created DESC

The above query for example sorts by ascending order of status, descending order of priority and descending order of creation date.

Reference

The Advanced Searching page of JIRA documentation describes how to search and at the bottom has links to reference pages on fields, operators, keywords and functions. These references are what I check to create my queries.