JQL: Get Started with Advanced Search in Jira

The operator compares the value of the field with one or more values or functions on the right, such that only true results are retrieved by the clause. The “IN” operator is used https://deveducation.com/ to search for issues where the value of the specified field is one of multiple specified values. The values are specified as a comma-delimited list, surrounded by parentheses.

what is jql

The “WAS NOT” operator is used to find issues that have never had the specified value for the specified field. The “WAS” operator is used to find issues that currently have or previously had the specified value for the specified field. Let’s take a look at a visual representation of a set of issues that get returned from JIRA. JIRA gives suggestions at each step of the way for each of the three components of our query. When you see the value you’d like to select, you can use the arrow keys or mouse to select it. Often times you may want to have the query reference a set of items.


Perform searches based on the released versions (i.e. versions that your Jira administrator has released) of a specified project. You can also search on the released versions of all projects, by omitting the project parameter. Find issues in projects that are led by a specific user. You can optionally specify a user, or if the user is omitted, the current user will be used.

what is jql

This result is better, but now I’m curious to know what didn’t make last sprint and got moved into this sprint. Now let’s see which issues got fixed in the last release. Intermediate Jira Software users who are new to JQL and want to deepen their knowledge of Jira’s features. And finally, you’ll test what you’ve learned in a simulated version of Jira Software. When you have hundreds of Jira issues, finding the right one can be a challenge. This result is better, but you can narrow it down even more.

You don’t have to be technical to use JQL

Predicates form the basis of the where clause, the having clause and searched case expressions. They are expressions which resolve to a truth value, generally TRUE or FALSE, although boolean comparisons involving NULL generally resolve to UNKNOWN. There are a few specialized expressions for working with collection-valued associations.

  • Hibernate generally understands the expected type of the parameter given its context in the query.
  • What if we want a list that always shows the issues fixed in the last release whenever it was run?
  • The distinction in this specific example is probably not that significant.
  • Returns issues that have an SLA that is running, regardless of the calendar.

Even if the entities are mutable, you can still fetch them in read-only mode, and benefit from reducing the memory footprint and speeding up the flushing process. The first query retrieves the complete total of all orders. The second retrieves the total for each customer, grouped by each customer. See also Special case – qualified path expressions as there is a good deal of overlap. Similar to elements except that indices refers to the collections indices (keys/positions) as a whole. Used to refer to the elements of a collection as a whole.

Affected version

Often used in conjunction with ALL, ANY or SOME restrictions. Abbreviated form for casting a value as character data. The third argument (optional) is used to denote a position from which to start looking. The second argument denotes the starting position, where 1 is the first character of the string. Variable argument length of 2 or more string values to be concatenated together.

what is jql

It is possible for your Jira administrator to change the name of a resolution, which could break any saved filter that rely on that name. Resolution IDs, however, are unique and cannot be changed. You can search by project name, by project key or by project ID (i.e. the number that Jira automatically allocates to a project).

what is jql

For queries that are cacheable, defines a specific cache region to use. Both HQL and JPQL are non-type-safe ways to perform query operations. Criteria queries offer a type-safe approach to querying. Search for issues jql queries examples that have open reviews on linked Crucible instances. Search for issues that have open or closed reviews on linked Crucible instances. Search for issues that have successful deployments on linked Bamboo instances.

This would tell you how many issues were out of scope in the last sprint and couldn’t be completed. Search for requests that were created on, before, or after a particular date (or date range). Search results are relative to your configured time zone (which is by default the Jira server’s time zone). Search for issues tagged with a label or list of labels.