JQL Cheat Sheet a gift of Atlassian Jira www MrAddon.com ®: Jira & Confluence Administration Support Blog & Ethereum Dev Blog ®

If you have installed JIRA extensions, some extensions may customize certain fields. For example, if you want to find issues with the status «closed,» the field would be «status.» For each condition, find the corresponding field from the list of fields below.

You can even create custom software that runs SQL queries to retrieve data and presents the information in intuitive ways. If you have many conditions, you can use parentheses to control the priority. Please note that the field list above is the built-in list in JIRA.

Similar to Atlassian jql-cheat-sheet-2 (

Atlassian Jira is meant to be used as a collaborative project management tool. Since the purpose of JQL queries is to retrieve information from Jira based on advanced user needs, it needs to follow a certain pattern or structure. This detailed guide about JQL or Jira Query Language will set you on the path to success with sufficient breadth & depth of knowledge. It is full of practical examples & points you in the right direction for detailed documentation. The “in” keyword will include any item that matches any item in the list.

Simple, check the entire query below & notice how we have added the OR keyword, used brackets to combine two seemingly different criteria together. The entire list of operators along with their usage can be found here. These are nothing but a medium to compare the fields & corresponding values. DM me if you’d like a batch of printed copies for your team and I’ll post by snail mail (to addresses in the Uk).

Values in Jira Query Language

This guide will be incomplete without the mention of Jira service management. The list of JQL keywords is actually small & pretty much self-explanatory. Following keywords are available to use in Jira – AND, OR, NOT, EMPTY, NULL, ORDER BY. That’s the primary role of keywords in the context of Jira query language. The most simple search feature in Jira is the search box at the top right of your screen.

In your query, you will seek to retrieve specific issues that meet certain conditions. What these conditions are, is going to be dictated by the type of field involved & the possible values for that field. Do thought experiments & try to guess what a Scrum master might ask from you as opposed to a project manager who is managing 3 different projects. If you seem to be using some specific Jira jql queries often, turn them into a saved filter. There are numerous benefits of jql queries over the basic search available in Jira. Designing an advanced jql query will need some way to connect multiple search criteria together.

Limitations of Basic Search in Jira

In fact, Atlassian marketplace boasts of a number of popular apps that are built to extend the power of JQL & a few others that are built on the power of JQL. So it is natural for anyone who wants to use Jira to learn writing JQL queries. When you have hundreds of columns and tens of thousands of rows, it’s much easier to use a database to store information and use Structured Query Language (SQL) to access the data.

Based on your query condition, locate the corresponding operator from the list of 17 operators below. As we have seen above, JQL is a powerful tool with a vast array of functions, operators, and keywords. Here are some practical tips to help you enhance your Jira advanced search abilities. Here’s a handy tip – use parentheses to group related elements together. This list does not end here, but it should definitely give you an idea into the depth of function availability for advanced search in Jira.

Jira Categories

Whether it’s in a list or not in a list is denoted by ‘IN’ or ‘NOT IN’. Advanced JQL queries section led the discussion with the nuances & then dived deeper into practical examples. These examples illustrated how you can tackle real-world scenarios. By practicing jira query examples with these examples, you can better understand how to apply these queries to your specific needs. One of the best ways to improve your JQL skills is to practice creating queries. Give your filter a meaningful name so you can easily identify it later.

In this query the “is empty” statement only includes issues where the value of the assignee field is blank. The value -1d evaluates to 1 day behind the current date when the query is run. As a result, the above query will return all issues that do not have an assignee that are at least one day old. A field, operator, and function can together form a query condition. AI is definitely getting better & better with this, however one can never be 100% confident of its accuracy – especially when dealing with complex queries.And then there’s one more reason.

Similar to Atlassian jql-cheat-sheet-2

In the above example it will return all of the blocker and critical bugs in projects A, B, and C. You can also search issues from the “Issues” section in the dropdown menu. Whether it contains or doesn’t contain certain characters is indicated by ‘~’ or ‘!

For example, if you wanted to see all the critical bugs created in the last 30 days from project AR that are not fixed – this is what the basic search would look like. Since JQL is basically an advanced way to search issues in Jira, it is the issue navigator where you can write the jql query. Easiest way to navigate to the issue navigator is by using the ‘View all issues’ menu item available under the ‘Filters’ dropdown in the top navigation of Jira. This section will focus on dissecting a handful of complex queries to deepen your understanding of how Jira jql queries work in practice.

This is extremely helpful for organizations that have service level agreements (SLA) with their customer base. A JQL query can easily find the issues that are not meeting that SLA. You can filter on any field available in Jira (depending on the selected project(s)). That’s why we have developed an app for Jira cloud that lets you search any such entities on your Jira instance. And the good thing is that it takes all its structure from the Jira JQL. Just enter your query in plain English & it will get converted into JQL automatically.

• What these conditions are, is going to be dictated by the type of field involved & the possible values for that field.
• AI is definitely getting better & better with this, however one can never be 100% confident of its accuracy – especially when dealing with complex queries.And then there’s one more reason.
• Simple, check the entire query below & notice how we have added the OR keyword, used brackets to combine two seemingly different criteria together.
• Remember how Jira itself converted basic search into the JQL query?
• When you have hundreds of columns and tens of thousands of rows, it’s much easier to use a database to store information and use Structured Query Language (SQL) to access the data.
• It goes beyond the basic search & lets you dig deeper into the data with advanced features such as operators, functions, customizations & more.