In this article, we will dive into the world of Jira Query Language (JQL) and unveil the secret to smartly managing and finding specific issues. With Jira, the go-to project management tool trusted by countless organizations worldwide, you can streamline workflows and improve productivity. The query will return JSON which you can then process in your client application. 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.

See also startOfDay, startOfWeek, and startOfYear; and endOfDay, endOfWeek, endOfMonth, and endOfYear. It is possible for an issue to belong to both a completed what are JQL queries and how to use them sprint(s) and an incomplete sprint(s). In most cases you don’t have to use @TypeName for ValueObjects. For example, querying by ValueObject class relies on it.

Work Management

If the time unit qualifier is omitted, it defaults to the natural period of the function, e.g. startOfDay(„+1“) is the same as startOfDay(„+1d“). Search for issues that are due by the end of the last day of the current week. By default, this function considers Saturday to be the last day of the week.

Once a filter is created, you can select it to share it with other users. You can set up your filters to appear on your dashboard. That way, you’ll have access to your search results with a single glance. If you find yourself needing to search the same query on a regular basis, you can save it for later use. For this example, let’s say we want to find all issues that are urgent and not done within a specific Epic link.

Component

Search for issues that are assigned to a particular sprint. The search is based on either the sprint name or the sprint ID (i.e. the number that Jira automatically allocates to a sprint). You can search by resolution name or resolution ID (i.e. the number that Jira automatically allocates to a resolution). Search for requests by the channel that they were created by.

Just like English or French, JQL has its own syntax and vocabulary. This article will walk you through the key aspects of JQL. With some practice, you will be able to create your own structured queries in no time. If still navigating Jira using JQL feels daunting, there is a solution within your reach.

Each field provides a different piece of information to its users. The most popular examples of fields include status, assignee, and priority. In this example the person filing the bug is stored in the reporter field. JIRA also has a project field that matches the issue key.

• This is really very useful for any new Jira users looking for learning JQL search capabilities in Jira.
• Returns issues that whose most recent SLA has missed its goal.
• For example, you could search for all requests that were emailed to the service project, or all requests that were sent from a customer portal.
• In the example, we show how to query for changes made on any domain object.
• That is, typing status WAS NOT IN („Resolved“,“In Progress“) is the same as typing status WAS NOT „Resolved“ AND status WAS NOT „In Progress“.