When constructing your JQL query, it’s important to tell Jira where it should search for issues by including or excluding specific projects or boards. Jira’s Advanced Search page provides a user-friendly interface for building complex JQL queries. Here, you can combine jql query multiple fields, operators, and values using an intuitive dropdown system. The page also provides auto-complete suggestions, helping you avoid syntax errors and construct your queries more easily. Why is JQL so crucial in the Jira ecosystem, you might ask?
Note the Syntax Help link, which opens a reference page to the JQL language. Often times you may want to have the query reference a set of items. The query states that the company must be Acme, the item must be a cookie, and the quantity needs to be three. Since we want items that meet all three criteria, we use the keyword “AND”, which means that the conditions to the left and right of AND have to be met. You can also use OR, which means that only one of the conditions needs to be met.
JQL search in Jira Service Management
We have covered some of the commands in the Advanced JQL search mode. For more information, check out the official Atlassian documentation. If you are looking for assignees who belong to a certain group, you can use membersOf() and specify the group name in brackets. 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.
This ensures that everyone understands what a specific filter does. And avoids other users creating duplicate filters if they’ve missed the point of an already existing filter. If you find yourself needing to search the same query on a regular basis, you can save it for later use.
Example JQL queries for board filters
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). 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. You can do a great deal with fields, values, operators, and keywords.
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. With ScriptRunner you can also not only use more JQL values but create your own as well.
System Status
Using search in Jira can help you gain key project insights and answer questions that are relevant to the team. The three flavors of search in Jira — quick, basic, and advanced — can help you find important information about your projects. For example, you can run this command in the terminal on the Macintosh or Linux workstation. (Windows users will need to get curl.) If we want to grab all of the duplicate issues from the ANERDS project we could simply call the search REST endpoint.
It can often be overwhelming to start with a long and complex query when performing your search. So you could just start with a wide search and narrow down from there. A function is a pre-made command that users can plug into their query to return certain values.
Create a seperate board for completed issues
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. Or let’s say you needed to figure out if your project has scoping problems. You could narrow your search for issues that are not closed in the current sprint AND that were previously assigned to another sprint.
Jira Query Language (or JQL) is one of the most powerful tools available in Jira. These are my observations formed from current experience in answering the most frequent questions of users. You can filter on any field available in Jira (depending on the selected project(s)). You can also search issues from the “Issues” section in the dropdown menu.
The “-” or “+” sign determines whether the current value lies in the past or in the future. In the above query, Jira would return a list of issues sorted by assignee first, then sort by due date for all issues with the same assignee. 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. Power users who employ Jira on a daily basis may already have a grasp of the Jira query language.
- 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.
- With a JQL query, you can filter out the required issues and carry out the bulk change using Tools in the top right-hand corner.
- [14] The relationship stems from the equivalence of the seven basic PEG operations and the jq constructs shown in the following table.
- You can also use OR, which means that only one of the conditions needs to be met.
- The language supports a namespace-based module system and has some support for closures.
- The page also provides auto-complete suggestions, helping you avoid syntax errors and construct your queries more easily.
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. If you double-click on “project”, you will see a drop-down menu where you can choose one of the possible fields. Once a filter is created, you can select it to share it with other users.
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.
