Advanced searching functions reference Jira Software Data Center 9 16 Atlassian Documentation

The “in” keyword will include any item that matches any item in the list. As you can see in this example, parentheses can turn our example JQL query around. This query would return resolved issues that either belong to the Teams in Space project or are assigned to captainjoe. For more information on fields, operators, keywords and functions, see the Reference section. A simple query in JQL (also known as a “clause”) consists of a field, followed by an operator, followed by one or more values or functions.

If you are looking for assignees who belong to a certain group, you can use membersOf() and specify the group name in brackets. The most simple search feature in Jira is the search box at the top right of your screen. If you’re a Jira admin, note that this list is hard coded in the JqlStringSupportImpl.java file. These words need to be surrounded by quotation marks (single or double) if you wish to use them in queries. Using “WAS NOT IN” is equivalent to using multiple WAS_NOT statements, but is shorter and more convenient.

Additional JQLs with Atlassian Marketplace apps

If you’d like to see the operations described below in action, go ahead and check out our video tutorial. To view a detailed information about functions and how to use them for advanced searching, check out Functions reference page. To view a detailed information about keywords and how to use them for advanced searching, check out Keywords reference page. To view a detailed information about operators and how to use them for advanced searching, check out Operators reference page. To view a detailed information about fields and how to use them for advanced searching, check out Fields reference page.

It allows you to search for different document types in the attachment of an issue, and more. Start your free trial now and enjoy all the benefits of extended search functionalities. It is also possible to display all the issues that have been created in the last 10 days, for example. In this case, you write not a specific date, but a period of time. The “-” or “+” sign determines whether the current value lies in the past or in the future. With a JQL query, you can filter out the required issues and carry out the bulk change using Tools in the top right-hand corner.

The basics of JQL Syntax

Search for issues that have merged pull requests on linked Bitbucket instances. Note that this query will also return issues with declined requests. Search for issues that have declined pull requests on linked Bitbucket instances.

It’s a more flexible solution than using assignee in (user1, user2, user3). In this query the “is empty” statement tells JIRA to return only 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 and haven’t been updated in the past day. In this example the person filing the bug is stored in the reporter field.

JQL-based archeology with history operators

What the sorting does is show us the most recent issues first. We use the DESC keyword to sort in reverse (newest to oldest) so we focus our attention on the most important issues first. Perform searches based on the unreleased versions (i.e. versions that your Jira administrator has not yet released) of a specified project. You can also search on the unreleased versions of all projects, by omitting the project parameter.

See also startOfDay(), startOfWeek(), startOfMonth(), endOfDay(), endOfWeek(), endOfMonth(), and endOfYear(). See also endOfDay(), endOfMonth(), endOfYear(), startOfDay(), startOfWeek(), startOfMonth(), and startOfYear. See also endOfDay(), endOfWeek(), endOfYear(), startOfDay(), startOfWeek(), startOfMonth(), and startOfYear(). Consider that the “earliest” is determined by the ordering assigned to the versions, not by actual Version Due Dates.

Jira Cloud Support

See also startOfDay(), startOfMonth(), startOfYear(), endOfDay(), endOfWeek(), endOfMonth(), and endOfYear(). Perform searches based on the start of the current month. See also startOfDay(), startOfWeek(), startOfYear(),  endOfDay(), endOfWeek(), endOfMonth(), and endOfYear(). Search for issues that are assigned to a Sprint that has not yet been completed. Consider that the “latest” is determined by the ordering assigned to the versions, not by actual Version Due Dates.

In other words, it allows you to search for issues that are not assigned to anyone. The “WAS NOT IN” operator is used to search for issues where the value of the specified field has never been one of multiple specified values. The “WAS IN” operator is used to find issues that currently have or previously had any of multiple specified values for the specified field. The “NOT IN” operator is used to search for issues where the value of the specified field is not one of multiple specified values. The IS NOT operator can only be used with the EMPTY or NULL keywords.

The WAS NOT IN operator is used to search for issues where the value of the specified field has never been one of multiple specified values. The WAS IN operator is used to find issues that currently have or previously had any of multiple specified values for a specified field. ~ operator is used to search for issues where the value of a specified field doesn’t match a specified value. The NOT IN operator is used to search for issues where the value of a specified field isn’t one of multiple specified values.

• A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or Jira system fields.
• And I cannot agree enough with @Evgenii regarding the use of parentheses – this has solved my issues more times than I can count.
• If you’re a Jira admin, note that this list is hard coded in the JqlStringSupportImpl.java file.
• Once the query is complete, JIRA validates the JQL and lets us know the syntax is correct by the green check in the left and side of the text entry box.

Search for issues that were updated by a specific user, optionally within the specified time range. Find issues in projects where you have a specific permission. Also note, this function is only available if you are logged in to Jira. A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or Jira system fields. In a clause, a function is preceded by an operator, which in turn is preceded by a field. This page describes information about functions that are used for advanced searching.

You don’t have to be technical to use JQL

JIRA also has a project field that matches the issue key. For example, the issue PIPELINE-2 is in the PIPELINE project. Again, we can set up multiple jql query conditions joined by the AND keyword. Effective project management requires specific metrics from the issue tracker relevant to your project.