X

Video Tutorial: JQL Advanced Enhanced Search Que ..

Advertisement

Find issues where the status was Done for some assignee during last year. Visit the Jira product guide to learn more about JQL, advanced search with use cases, and more. You can filter on any field available in Jira (depending on the selected project(s)). The most simple search feature in Jira is the search box at the top right of your screen. In addition to temporal functions, there are also functions for people. We have already come across the currentUser, which stands for the user who is currently logged in.

  • Visit the Jira product guide to learn more about JQL, advanced search with use cases, and more.
  • What’s really handy about Jira JQL is that it will auto-suggest as you type.
  • This checks whether a field is empty, i.e. without a value, or not.
  • Whereas the JQL function on its own would return only what is due at the end of the current day.

You can create custom widgets based on JQL searches and display them on your dashboard, making it easier to track and monitor your work across projects. The query will return JSON which you can then process in your client application. Let’s take a look at a visual representation of a set of issues that get returned from JIRA. Regularly review saved filters to ensure they are still relevant and performing well. Use the ~ operator to perform a text search within fields. If you want to find issues that are linked to a particular issue, use the linkedIssues() function.

What is JQL?

While some searches are simple, others can be complex and require knowledge of JQL (Jira Query Language). When searching JIRA, it’s easy to perform searches that return too many issues. In the above example both diagrams have the same number of issues we care about (issues with A on them) but the first query isn’t specific enough. Development managers often have to find areas of risk in their programs. Good queries often take a bit of refinement as they get developed. Let’s see if we can find some risky areas in our project PWC.

Advertisement

On the other hand, JQL sorting will allow you to order the list of returned issues in a specific manner using the keyword “ORDER BY”. In the above search, you’re searching for issues with an Epic Name (field) that is equal to (operator) “Audio Development” (value). A field is a piece of information that describes issues – this is what you fill in when you use basic searches. All queries are made up of fields, operators, values, and keywords. Functions are powerful because they can react dynamically as the environment changes. If users are added to the test-engineering group, this query will start including issues assigned to the new members.

JQL: the most flexible way to search Jira

You can find saved searches (also known as Saving your search as a filter) in the left-side panel, when using advanced search. If the left panel is not showing, hover your mouse over the left side of the screen to display it. 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.

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. 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.

Introduction to JQL Search

If you’re a Jira admin, note that this list is hard coded in the JqlStringSupportImpl.java file. We have covered some of the commands in the Advanced JQL search mode. For more information, check out the official Atlassian documentation. Once you end up with several filters, it’s important to use a consistent naming nomenclature. You can even send your subscriptions to other users as well. With Advanced Searching, you’ll be forming your own JQL queries.

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. You can set up your filters to appear on your dashboard.

Understanding the Basics

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. Find issues with the specified keyword in the summary, description, and comments. UpdatedBy() is a function which allows you to find all the issues that have been updated by a certain user (whose name is specified in brackets). This ensures that everyone understands what a specific filter does.

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 jira query examples bugs in projects A, B, and C. This is extremely helpful for organizations that have service level agreements (SLA) with their customer base.

Overview of Jira Query Language Interface

However, sometimes a query created using an advanced search may not be able to be translated into a basic search. 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. With the above search, you’ll get a very specific view of high or urgent priority issues that were carried over from the last sprint.

Basic searches in Jira are useful up to a certain point. Jira Query Language (or JQL) is one of the most powerful tools available in Jira. Knowing how to search your Jira instance effectively can literally save you hours of work.

Jira JQL: advanced search queries made easy

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. Find the list of issues where the status was Done for a current assignee during the last month. This query will return issues resolved between January 1, 2024, and February 1, 2024. We recommend switching to List View for a better overview.

Categories: Uncategorized
Kishwar:
Advertisement
Related Post
Advertisement