As a result, the above query will return all issues that do not have an assignee that are at least one day old. Hopefully, you now know enough about Jira Query Language (JQL) to start writing your own queries. Compared to the basic search, this filtering method is in a league of its own.

The result remains the same, but the query is displayed instead of the basic search user interface. To search for updates that have been made in the past, you can use WAS or CHANGED operators. JQL works only for some fields with history changes, which include Assignee, Fix Version, Priority, Reporter, Resolution, and Status.

Issues Linked to Filtered Issues

Remember that Jira’s flexibility allows you to create custom fields, workflows, and issue types, so you can adapt your JQL queries to your specific project’s needs. By mastering these simple issue searches, you will be able jira query language to quickly locate and filter issues in Jira based on various criteria. These foundational JQL queries will serve as building blocks for more complex searches and enable you to effectively manage your projects in Jira.

jql language

In this case, the app only displays the elements with a “to do” status. The general structure of the project is still visible, which provides a point of reference to the project as a whole. But all the other elements I don’t need to see at the moment are hidden. So much so that other Jira-based software use it for other purposes. Our PPM software, BigPicture, unleashes the power of JQL in reporting, configuration, and visualization.

2 Why use JQL?

Take advantage of this feature to ensure the accuracy of your queries and to discover available options that you may not be aware of. Jira Query Language (JQL) is a powerful tool that allows you to search and filter your Jira issues with precision. To make the most out of JQL and optimize your workflow, it’s important to follow some best practices.

jql language

However, we’ve surprised ourselves with how quickly it has become a commonly used tool at Mixpanel. Every day, more people find new uses for JQL, and more analytics questions get answered. Similarly, we’re blown away by the adoption among our beta customers. JIRA Query Language or JQL offers a great flexibility when searching and finding issues in JIRA. Find issues where priority changed from medium to low during the past 24 hours. Find issues where the status was Done for some assignee during last year.

JIRA Product Owner Copilot

Experiment with different combinations of operators and explore the possibilities to master the art of JQL querying. JQL offers a high degree of customization, allowing you to tailor your Jira experience to meet your specific needs. By creating custom filters and saved searches, you can save time and effort by quickly accessing the information you frequently require. JQL also enables you to create custom dashboards and boards, providing a personalized view of your projects and tasks. The catalog of Jira functions can be expanded with third-party tools.

  • Find issues where the status was Done for some assignee during last year.
  • Remember to start with simple queries, understand your data model, and utilize the right operators, functions, and keywords.
  • In JQL, the “labels” field is used to search for issues based on their labels.
  • Any time you open a text box and start typing, the editor will show a list of suggestions, which makes creating an advanced search query easier.

You can replace “John Doe” with the actual username or display name of the assignee you are searching for. This query will return all issues that are currently in the “Open” status. You can replace “Open” with any other status name to search for issues in different states.

JIRA REST API User Impersonation

With JQL, users can search for issues based on a wide range of criteria, such as issue type, status, assignee, reporter, priority, labels, components, and more. It also supports advanced features like searching by date, subtasks, linked issues, epics, sprints, and custom fields. JQL provides a comprehensive set of tools to meet the diverse needs of Jira users across different projects and workflows.

In the next section, we will explore how to filter issues by labels using JQL. By combining priority with other criteria, you can create powerful JQL queries to precisely search for the issues that matter to you. By executing this query, you will retrieve all the issues that have been reported by John Doe.

OR Operator

In this section, we will explore various techniques to query issues using the assignee field in JQL. This query will return all issues that were previously in the “Open” status but have since changed within the last 7 days. You can modify the status and time frame according to your requirements. This query will return all issues except those that have the issue type “Epic”. This query will return all issues that have the issue type “Bug”.

jql language

With JQL, you can easily search for issues based on their priority level, allowing you to focus on the most important tasks at hand. In this section, we will explore how to effectively search for issues by priority using JQL. This query will return all the issues where the assignee field is set to “John Doe”.

1.7 Querying by Priority

Instead of drop-down lists of categories and checkmarks, advanced searches require text queries. This method provides much more customizability in defining the search parameters. To filter the list, use checkmarks from various Jira fields, such as project, type, status, or assignee. Furthermore, you can add text or even expand the list with custom fields to filter with more precision. To achieve the flexibility we wanted, we needed to add a general-purpose query interface to Arb. Our goal at the outset of the project was to choose a query language that was simple, familiar, powerful and fast.