Jira JQL cheat sheet

Owned by Rina Nir _RadBee
Last updated: Jun 18, 2021
1 min read

JQL reading list and references:

  1. https://www.atlassian.com/software/jira/guides/expand-jira/jql

  2. https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-14

  3. https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html

JQL life hacking

Use a Jira filter

  1. In Jira, define a search that retrieves exactly the set of issues you need;

  2. Use the “Save as” to save it as a filter. Give the filter a meaningful name, like: “Open stories”.

  3. Use this JQL inside the Jira snapshots macro: filter=”Open stories“

All issues in a project

For all issues in a project “Space ship” with project key PKEY, use any of these JQLs inside the Jira snapshots macro:

  1. project=PKEY

  2. project=”Space ship”

All open issues in a project

Typically, open issues in Jira will be those for which the ‘Resolution’ field is not set. Assuming that the project “Space ship” with project key PKEY, Use any of these JQLs:

  1. project=PKEY AND resolution != Unresolved

  2. project=PKEY AND resolution != Unresolved