Writing Complex JQL Queries in Jira Software : Atlassian

On the other hand, “OR” will return all issues that fulfill either of your conditions. You can view a list of all fields in Jira’s documentation. Search for issues that have successful and unsuccessful deployments on Bamboo instances. This field is only available if time tracking has been enabled by your Jira administrator, and can only support the CONTAINS operator (“~”). Only available if issue level security has been enabled by your Jira administrator.

• You can restrict the search to links of a particular type.
• Version order is determined by the order versions are placed in on the Releases page in the project.
• As an Atlassian partner we’ve done so in the past with multiple customers through JQL consultations or training sessions.
• In advanced search, you can use queries to find your issues.
• Queries are a series of elements or parts, like fields, operators, and values, that are strung together to form a structure.

In advanced search, you can use queries to find your issues. Queries are a series of elements or parts, like fields, operators, and values, that are strung together to form a structure. These simple https://deveducation.com/ queries are connected using keywords or functions that lead to complex queries, depicted in the 2nd example above. Search for issues that are assigned to a particular affects version(s).

development[pullrequests].declined

The “latest” is determined by the ordering assigned to the versions, not by actual Version Due Dates. Find issues that you have recently viewed, i.e. issues that are in the ‘Recent Issues’ section of the ‘Issues’ drop-down menu. Returns issues that have an SLA that has completed at least one cycle. Search for issues that are assigned to a completed Sprint. Returns issues that whose most recent SLA has missed its goal.

Search results are relative to your configured time zone (which is by default the Jira server’s time zone). Note that the Lucene value for Customer Request Type, is portal-key/request-type-key. While the portal key cannot be changed after a service project portal is created, the project key can be changed. The Request Type key cannot be changed once the Request Type is created. Only applicable if your Jira administrator has created one or more custom fields. To meet user expectations, Atlassian Marketplace offers some additional apps with JQL functions.

Unlock the full power of JQL to find issues quickly

And avoids other users creating duplicate filters if they’ve missed the point of an already existing filter. Once a filter is created, you can select it to share it with other users. If you find yourself needing to search the same query on a regular basis, you can save it for later use. It can often be overwhelming to start with a long and complex query when performing your search.

The “IS NOT” operator can only be used with EMPTY or NULL. That is, it is used to search for issues where the specified field has a value. That is, it is used to search for issues where the specified field has no value.

What are elements of a JQL query?

Perform searches based on the latest released version (i.e. the most recent version that has been released) of a specified project. Search for issues that are assigned to a sprint that hasn’t been started yet. Perform searches based on the earliest unreleased version in a project. 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. While typing, you can hover over the invalid text of your query to know more about the JQL error.

You can use a different day (for example, Monday) as the start of the week. The “WAS NOT IN” operator is used to search for issues where the value of the specified field has never jql does not contain been one of multiple specified values. The “NOT IN” operator is used to search for issues where the value of the specified field is not one of multiple specified values.