14 Nov Top 10 JQL queries for busy Scrum Masters The Hub, by Appfire
A number of JQL fields are particularly useful for project tracking. It can often be overwhelming to start with a long what are JQL queries and how to use them and complex query when performing your search. So you could just start with a wide search and narrow down from there.
For this example, let’s say we want to find all issues that are urgent and not done within a specific Epic link. Typing “AND” in your query will return issues that match both conditions of your search. You can also use “NOT IN” to identify everything that falls outside that query.
How a Sys Engineer helped a global leader in home security and automation reduce time spent on instance cleanup by 50%
A common example would be creating a custom dashboard to display information for stakeholders without requiring them to log in to Jira to sort through issues by hand. Keywords connect different and/or multiple parts of a query. There are many JQL plugins in the Atlassian Marketplace that can provide access to helpful functions which simplify queries. Alternatively, you can also try out our JQL Search Extensions for Jira app to quickly access the JQL queries shared above. With over 50 unique JQL search extensions not available in native Jira, get the right project information at the right time.
Jira is very flexible in what it will allow an end user to configure, from issue types and workflows to security schemes and permissions. Each of these can appear in various forms inside the JQL, and some are present in the JQL above. This complexity means that the JQL query above gets converted to about 100 lines of SQL joining across 26 tables to accommodate this flexibility. First, while you’re looking for a specific detail in Jira, you’ve to start from the ‘search’ bar.
Consistent Filter Naming
The rest of the query remains the same, except for the addition of an “OR” keyword and a query for high priority issues. Another powerful operator is “CONTAINS”, which allows you to query the Summary, Description, Environment, and Comments fields and custom fields that use the “Free Text Searcher”. All queries are made up of fields, operators, values, and keywords. Search for issues that were last updated on, before, or after a particular date (or date range). Search for requests that were created on, before, or after a particular date (or date range). Search results are relative to your configured time zone (which is by default the Jira server’s time zone).
Search for issues where the time spent is set to a particular value (i.e. a number, not a date or date range). Use “w”, “d”, “h” and “m” to specify weeks, days, hours, or minutes. You can search by status name or status ID (i.e. the number that Jira automatically allocates to a status). If you have multiple sprints with similar (or identical) names, you can simply search by using the sprint name — or even just part of it. The possible matches will be shown in the autocomplete drop-down, with the sprint dates shown to help you distinguish between them. You can search by priority name or priority ID (i.e. the number that Jira automatically allocates to a priority).
Multiple efforts are underway to improve horizontal performance at scale to JQL in Jira Cloud. There are multiple options being considered for database scalability, including read replicas, but these can be costly to run at scale when storing large quantities of data with high load. Given it’s a mix of both microservices and a very large legacy monolithic codebase, extra care needs to be taken to ensure existing code continues to work.
- If you need to be able to search specifically for issues with an outward description of “blocks”, for example, a Jira administrator must change the name of the link type to something else.
- Is it possible to check Sprint is started and sprint is completed/closed?
- If you find yourself needing to search the same query on a regular basis, you can save it for later use.
- The “IN” operator is used to search for issues where the value of the specified field is one of multiple specified values.
Daniel Turczanski is a Chief Product Architect at Appfire. He has over 10 years of experience in IT and as a software consultant in agile projects. He’s been working on JQL Search Extensions leading the product and technical development. For example, Jira supports a function called membersof() that you can use to see all the issues assigned to members of a group. Groups can be defined inside of Jira or come from existing groups in your company’s preexisting directory servers.
To know all the other fields available, check out the link. However, as the number of projects and boards grows, it becomes increasingly challenging to navigate through the vast sea of issues. In the fast-paced world of project management, staying organized and effectively tracking tasks and projects is crucial for success. This filters issues whose SLA clock is running or not running according to the SLA calendar, not conditions. This filters out issues where the last SLA cycle has failed to meet its target goal. This example shows you how to create a Jira app that uses the REST API.
This guide contains different examples of how to use the Jira REST API, including how to query issues, create an issue,
edit an issue, and others. Fields are columns that contain different types of information in the system (like issue type and priority). You can also add this JQL query to find issues that have more than a certain number of dependencies. The higher the number, the more important it is for the issue to be staged in a sprint and completed so as to not cause a blocker.
No Comments