Jira Query Language enables anyone to build queries that can be executed in Jira to produce a set of results. These queries are very similar to SQL, GraphQL, and other query languages that enable easy access to large databases or data sets. To get the list of subtasks in Jira, use the object “Parent” and specify the parent issue key(s). So much so that other Jira-based software use it for other purposes.

jql query examples

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. You can even create custom software that runs SQL queries to retrieve data and presents it in intuitive ways. JQL is a versatile tool that enables powerful searches in Jira.

JQL Builtins

Using a human readable syntax, JQL provides users with an opportunity to utilize more complex operators and logic than what is available in basic search mode. Keywords are specific words in a language such as in, or, and, is, and so on. When you’re using JQL, you can do a little bit more than you can with Basic Search, but really it is just the back-end of the basic search, exposed. Although the name may sound super technical, once you spend some time creating filters of your own you’ll see that it is pretty straightforward. On top of that, Atlassian has made using JQL even easier to learn with the auto-complete functionality. When you start typing, you’ll get suggestions that can push you in the right direction.

jql query examples

JSU is pulling the emergency brake before things get out of control. The result remains the same, but the query is displayed instead of the basic search user interface. I’ll tell anyone who will listen that if you’re looking to expand your JQL knowledge, the best way to begin what are JQL queries and how to use them is to build your filters in the Basic Search. Then select that ‘Switch to JQL’ button next to your search bar to see what the JQL is behind what you’ve just built. The following functions provide lists of projects and components that match the provided regular expression.


It allows you to find changes (or snapshots) persisted with a given commit property. In this case, each given commit property must match with a persisted one. Field – Fields are different types of information in the system. Jira fields include priority, fix Version, issue type, etc.

Reasons to use the advanced search mode include utilizing the OR logical operator, dealing with unsupported fields, or using JQL functions. JQL, or Jira Query Language, is a powerful tool for creating advanced search queries in Jira. Sometimes, you’ll need to craft a JQL query to create a filter that precisely groups the issues you want to display on your dashboard or board. Advanced search allows you to build structured queries using the Jira Query Language (JQL) to search for issues. You can specify criteria that you can’t define in the quick or basic searches.


Here, currentUser() is a function that returns the logged in user’s identity. Jira Query Language (JQL) allows you to do some advanced searching in Jira’s search dialog. This is a very powerful feature provided by Atlassian in Jira. JSU extends JQL with additional placeholders, which will be replaced with the values of the current issue in transition. More advanced users can type their JQL query directly into the JQL query text field.

This query will find all issues with the “security-issue” label. This blog is intended to be a tutorial for those who have no experience with database queries or SQL queries to those who want faster access to information in Jira. Similar to the Field and the Keyword Reference, these operators can also be used to enhance the search results. The next step is to enter the value and then click on the Search symbol.

  • Use the skip parameter to define the offset of the first (most recent) Snapshot or Shadow
    that JaVers fetches from a repository.
  • On top of that, Atlassian has made using JQL even easier to learn with the auto-complete functionality.
  • A JQL function allows you to calculate various Jira data.

Leave a Reply

Your email address will not be published. Required fields are marked *