Jira supports AND, “+”, OR, NOT and “-” as Boolean operators. The Atlassian Community can help you and your team get more value out of Atlassian products and practices. If you’re a Jira admin, note that this list is hard coded in the JqlStringSupportImpl.java file. Once you end up with several filters, it’s important to use a consistent naming nomenclature. You can even send your subscriptions to other users as well.

It uses the project field, the EQUALS operator, and the value TEST. Once a filter is created, you can select it to share it with other users. That way, you’ll have access to your https://deveducation.com/ search results with a single glance. In the above query, Jira would return a list of issues sorted by assignee first, then sort by due date for all issues with the same assignee.

All Issues in a Project

You’ll avoid needing to login to Jira on a regular basis just to perform a query yourself. Jira JQL functions are especially powerful when combined with the other elements of JQL. Then you will get all resolved items from the Planning project as well as all resolved items assigned to Francis.

jira query language cheat sheet

The “WAS IN” operator is used to find issues that currently have or previously had any of multiple specified values for the specified field. This page describes information about operators that are used for advanced searching. Then you probably will have stumbled upon the search function in Jira. Be it while looking for a specific ticket, to automate workflows or to create reports.

Basic vs Advanced Searching in Jira

But if you want to tap into complex logic that is easily accessible, you’ll need functions. We also have a downloadable cheat sheet to keep close on hand as you perform searches with JQL. Copy and paste fields, operators and functions into the Jira search bar, as well as learn more advanced queries. Usage of the NOT operator over multiple fields may return results that include the specified excluded term.

jira query language cheat sheet

@Andrei Pisklenov _Actonic_, thank you for sharing this post! This is really helpful for new Jira users who want to learn about Jira’s JQL search capabilities. Thanks for sharing this article @Andrei Pisklenov _Actonic_ ! This is really very useful for any new Jira users looking for learning JQL search capabilities in Jira. When you click on “Advanced Search”, you’ll get a search bar with no pre-made filters. Each keyword has a specific meaning that further narrows the search, like “AND” and “OR”.

JQL: the most flexible way to search Jira

It uses the project field, the EQUALS operator, the value TEST,the AND keyword and the currentUser() function. In general, a query created using basic search will be able to be translated to advanced search, and back again. However, sometimes a query created using an advanced search may not be able to be translated into a basic search. Let’s say I’m trying to search which urgent issues are due in two days within a certain project (writing this article, for instance) and assigned to a specific user (me). Data is one of the most valuable resources in the world right now, but the way it is stored and accessed can impact its efficiency and usability. Spreadsheets are a great way to store information until they become unwieldy, and even a basic lookup on such sheets might crash the system, let alone advanced search.

jira query language cheat sheet

Queries in JQL help in finding the right data, be it issues, feature requests, or something else. Scope introduces qualifiers to whittle down the results, and sorting involves ordering the data to list the most important data first. The `ORDER BY` keyword, for example, can be used to order the results by `priority, `assignee` or other relevant attributes. Note that this function can only be used by logged-in users. Perform searches based on issues for which you have voted. Search for issues that were updated by a specific user, optionally within the specified time range.

jira query language cheat sheet

To find out the version of Lucene Jira Software is using, go to /Installation-directory/atlassian-jira/WEB-INF/lib and locate the Lucene jar files. These words need to be surrounded by quotation marks (single or jql contains double) if you wish to use them in queries. A number of JQL fields are particularly useful for project tracking. I’ve added +2 to the endOfDay() function because I needed to find out what is due in two days.

  • You can even build your own plugins with Java, JavaScript, CSS, and HTML skills.
  • You could narrow your search for issues that are not closed in the current sprint AND that were previously assigned to another sprint.
  • In addition to built-in JQL, the Atlassian Marketplace contains plugins with advanced JQL functionality.
  • An update, in this case, includes creating an issue, updating any of the issue’s fields, creating or deleting a comment, or editing a comment (only the last edit).
  • Find issues in projects where you have a specific permission.