Reasons to use the advanced search mode include utilizing the OR logical operator, dealing with unsupported fields, or using JQL functions. The “in” keyword will include any item that matches any criteria in the list. In the above example it will return all of the blocker and critical bugs in projects A, B, and C. This is extremely helpful for organizations that have service level agreements (SLA) with their customer base.

Moreover, Jira filters can be embedded into Confluence pages, making it easy to share the insights from your JQL queries with your entire organization. Jira allows you to save your JQL queries as filters for future use. These filters can be referenced in various areas of Jira, such as on Dashboards, in Agile Boards, or in other queries using the ‘filter’ keyword.

Use advanced search with Jira Query Language (JQL)

Additional fields can be added by clicking More and selecting the fields you’d like to search on. The filtering options of each field will dynamically update based on the type of the field. For example, date fields, such as createdDate, will display options to choose date ranges, while the assignee field gives a multi-select and user search tool.

JQL (Jira Query Language) is a powerful tool which allows you to base your search on criteria that you can’t specify in the basic search. The basic search provides the possibility to do this search with the dropdown menu but sometimes it reaches jira query language its limit. In this case, you can switch to advanced search which offers you tons of possibilities for special search functions. This article is intended to be a practical guide for anyone working with Jira, regardless of experience.

Create a seperate board for completed issues

JQL gives you the power to create custom search filters, which dramatically streamlines the project management process. With JQL, you can pinpoint specific tasks, monitor the progress of a project, generate detailed reports, and so much more. Irrespective of the size of your project or the number of issues you’re dealing with, JQL lets you zero in on the issues that are relevant to you.

The developers among you might have had a look at the advanced search in Jira as well. When saving filters for reuse, use clear and descriptive names. You can also share your queries and filters with other team members. Sharing filters allows others to use the same set of criteria to view issues.

Select all issues you are interested in

Effective project management requires specific metrics from the issue tracker relevant to your project. As an Atlassian partner we’ve done so in the past with multiple customers through JQL consultations or training sessions. To meet user expectations, Atlassian Marketplace offers some additional apps with JQL functions.

• The basic search provides the possibility to do this search with the dropdown menu but sometimes it reaches its limit.
• And I cannot agree enough with @Evgenii regarding the use of parentheses – this has solved my issues more times than I can count.
• Functions are powerful because they can react dynamically as the environment changes.
• Here, you can combine multiple fields, operators, and values using an intuitive dropdown system.
• Moreover, Jira filters can be embedded into Confluence pages, making it easy to share the insights from your JQL queries with your entire organization.

In all the queries we’ve discussed so far, the data is reflective of the current time the query was run. But values for fields like assignee, priority, fix version, and status often change over the course of an issue’s lifecycle. JIRA stores each update an issue goes through, known as an issue’s change history. We also have a downloadable cheat sheet to keep close on hand as you perform searches with JQL.

Text Searching with ~ and !~

All these elements can be combined in a multitude of ways to form very complex statements. The key is to start small and build up your statement one piece at a time, joining together multiple clauses with keywords, such as AND or OR. There is also an operator IS, which is used together with the keyword EMPTY (→ is or is not ). This checks whether a field is empty, i.e. without a value, or not. In other words, it allows you to search for issues that are not assigned to anyone.

They define the relationship between the field and the value. This introduction is only the proverbial tip of the JQL iceberg. There is much, much more that you can do, but you should start in the shallows before going into the deep blue sea. Once you master the elements above, you can then move toward more interesting cases, such as using JQL statements within Confluence pages.

JQL search in systems like Jira

And if that’s still not enough, sign up for JIRA Insiders – our monthly newsletter covering all things JIRA. Embrace transparency, foster a sense of belonging, form connections – and have fun along the way.

If you want to use the wildcard search not only for text fields but also for dropdown fields or label fields, then our PowerJQL plug-in is just for you. 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.

C. Building JQL Queries Using the Advanced Search Page

Using a human readable syntax, JQL provides users with an opportunity to utilize more complex operators and logic than what is available in basic search mode. Jira Query Language (JQL) is a versatile and powerful tool that allows users to create sophisticated queries to find issues in Jira. To get the most out of JQL, it’s important to follow some best practices. Here, we will explore advanced JQL best practices that can help you write efficient, maintainable, and effective queries. Jira’s Advanced Search page provides a user-friendly interface for building complex JQL queries.