Tutorials for Advanced Search in Jira

When you only use the OR keyword, all clauses will be treated as separate, and equal in terms of precedence. This is extremely helpful for organizations that have service level agreements (SLA) with their customer base. You can also search issues from the “Issues” section in the dropdown menu.

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. In this query the “is empty” what are JQL queries and how to use them statement only includes 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.

PotPlayer Keyboard Shortcuts

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. The “IN” operator is used 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. 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 “NOT IN” operator is used to search for issues where the value of the specified field is not one of multiple specified values.

As a result, the above query will return all issues that do not have an assignee that are at least one day old. The “in” keyword will include any item that matches any item in the list. In the above example it will return all of the blocker and critical bugs in projects A, B, and C. Jira Query Language (JQL) is a powerful tool that allows users to perform advanced searches in Jira. 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.

Atlassian Together

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 query will return all resolved issues from the “Teams in Space” project (clauses grouped by AND), and also all existing issues assigned to captainjoe. The advanced search permits you to build structured queries using the Jira Query Language to look for issues. You can specify criteria that you cannot use in the basic search (the ORDER BY clause, for example). Advanced search allows you to build structured queries using Jira Query Language (JQL) to search for issues within and across projects. Query results can be saved and used as filters and views across Jira (including boards).