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 jira query examples 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.
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.
Basic and Advanced Searches
It uses the project field, the EQUALS operator, and the value TEST. Find issues updated by some users during the past two weeks. This query will return tickets created within the last 2 weeks. With JQL, you can search for tasks created, updated, or resolved within a specific or relative date range. Jira Query language (JQL) is a must for everyone who wants to search data in Jira effectively. It can be more or less straightforward for experienced users and totally mystifying for those who are new to Jira.
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.
Tutorials for advanced search in Jira
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.
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 Search Features: Unleashing the Power of JQL
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.
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.
You don’t have to be technical to use JQL
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.
I recommend bookmarking this link – I find myself returning to it often to look up obscure queries. The docs page has a lot of content, so it’s helpful to do a “Ctrl/Cmd + F” so you can jump directly to a specific topic or keyword of interest. Here you can find a brief overview of Jira fields, operators, keywords, and functions used to compose JQL queries. For detailed description and examples of their usage for advance searching, check the links from the Reference column. JQL (Jira Query Language) query is used to search for issues in Atlassian’s Jira software based on certain criteria. Mastering it will help you retrieve specific information, filter out irrelevant data, and focus on what’s important.
JQL Add-Ons
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.
- First of all, let’s have a look at the standard search.
- Find issues currently part of an open sprint but not planned for any future sprints.
- In the above example it will return all of the blocker and critical bugs in projects A, B, and C.
- Find issues where the assignee is a specific user, and the status has changed from “Open” to “In Progress” within the last week.
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.
A real-time summary of project status, progress, and other metrics can be obtained by utilizing JQL queries. To view a detailed information about keywords and how to use them for advanced searching, check out Keywords reference page. 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.
Recent Comments