Before we delve into JQL tricks, let’s explore the different ways you can perform an issue search in Jira. Regularly review saved filters to ensure they are still relevant and performing well. This query finds all issues where the summary and description contains words starting with “roadmap” and “log”. And I cannot agree enough with @Evgenii regarding the use of parentheses – this has solved my issues more times than I can count.
- Jira’s advanced search functionality allows you to refine your JQL queries further.
- Additional fields can be added by clicking More and selecting the fields you’d like to search on.
- Watch the blogs in this space to get notified when new tips articles like this are posted.
- The “-” or “+” sign determines whether the current value lies in the past or in the future.
In the standard search, you can select values for different dropdown fields. 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.
Introduction to JQL: Standard & advanced search in Jira
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. First, let’s find all issues that have a description filled out. For this part, we’ll use the “description” field combined with two keywords (IS NOT, EMPTY). Efficient as it may be, Jira has its limitations when it comes to some search queries.
When you see the value you’d like to select, you can use the arrow keys or mouse to select it. Let’s say you want to view all the work assigned to you using a JQL filter. However, you only work on two projects within your entire organization. For more tips and assistance with Atlassian tools, feel free to get in touch with our team.
Only show your bugs in a bug fix team
Often times you may want to have the query reference a set of items. Using an AND would give only the area covered by both circles, but an OR returns all items in either circle. Generally speaking, AND will narrow your query and return fewer results, while using an OR broadens it and will return more results. 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.
The value -1d evaluates to 1 day behind the current date when the query is run. As a result, the above query will return all issues that do not have an assignee and haven’t been updated in the past day. In this query the “is empty” statement only includes issues where the value of the assignee field is blank. As a result, the above query will return all issues that do not have an assignee that are at least one day old. 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).
Operators
Find issues whose summary or description contain any of the listed words in a test project. When a query has to search through fewer issues, results load faster. You can use a JQL filter to make a board that shows the relevant issues based on whatever criteria you want. JQL is a flexible yet robust logic that can be used in a variety of different ways. You can filter on any field available in Jira (depending on the selected project(s)). JQL provides several functions that can be very powerful when used correctly.
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. From this point of view, it is a translation of the search query that you created earlier in the standard search mode. Functions are powerful because they can react dynamically as the environment changes.
What is JQL?
This interface is far more powerful than the Search box, but still has some limitations. Simply put, it is a very wide net with holes that are not specifically sized for the fish you want to catch. We have covered some of the commands in the Advanced JQL search mode.
For example, if you want to save money by looking for items on sale or store brand items, we can use this query. @Andrei Pisklenov [Actonic], thank you for sharing this post! This is really helpful for new Jira users who want to learn about Jira’s JQL search capabilities. Visit the Jira product guide to learn more about JQL, advanced search with use cases, and more.
Show all issues that are unscheduled or in an unreleased fix version
A JQL query can easily find the issues that aren’t meeting the SLA. If you are a Jira user or administrator, you’ve likely explored the search feature to find specific issues or lists of issues. While some searches are simple, others can be complex and jira query language require knowledge of JQL (Jira Query Language). Jira’s advanced search functionality allows you to refine your JQL queries further. In this query the “is empty” statement tells JIRA to return only issues where the value of the assignee field is blank.
The next simple search interface is the Search Issues screen. The basic version of this tool allows a user to filter based on any available fields in their instance. It is not limited to the small number of fields used by the Search box. The filtering is performed via an easy to use graphical user interface consisting of drop-downs and input fields. This interface is pre-set with some common fields, such as project, issue type, status, and assignee.
Basic JQL Search
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. 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.
