Introduction to JQL

So, here are my favorite 14 Jira queries, so that you can quickly summon up the tickets that you need. For each query, I’ll walk through what it does, how to enhance it, and how to weave it into your day-to-day product management processes. Keywords are specific words in a language such as in, or, and, is, and so on. This example will return all tickets in the project Team A created after the start of the current month and currently assigned to the user Tom. First, let’s find all issues that have a description filled out.

Once you understand what each one means, you can start building JQL searches. Plus, the JQL editor is like your fairy godmother—constantly looking over your shoulder to provide auto-complete suggestions if you’re ever in a jam. The great thing about the “was” operator is that it also includes the present. So, if I’m the current assignee of ticket MYPROJ-123, the query “assignee was clement” will still give me MYPROJ-123 in its results. JQL queries based on Portfolio for Jira context can be performed using the Parent Link custom field and JQL functions provided by Portfolio for Jira and ScriptRunner. The “Current User” context can be used with specific fields/custom fields like Reporter, Assignee, Watcher, Voter, and Any User Picker custom field.

Basic and Advanced Searches

For this part, we’ll use the “description” field combined with two keywords (IS NOT, EMPTY). All these elements can be combined in a multitude of ways to form very complex statements. The key is to start small and build up your statement one piece at a time, joining together multiple clauses with keywords, such as AND or OR. There are two ways BigPicture supports JQL in configuring Boxes – customizable data containers for your desired Jira sources. The first way uses entire projects, which are then narrowed down by your query.

And if you want to personalize the box even further, simply add a JQL query in the “narrow down” field. The catalog of Jira functions can be expanded with third-party tools. For example, BigPicture contains an extension called Enhanced JQL. It adds a number of app-specific functions to the search engine, which means users can sift through data in projects, programs, and portfolios even more effectively.

Atlassian Data Protection – Challenges in the Cloud

While basic search provides high-level access to issues, advanced search in Jira uses JQL to create queries to form more complex questions. Developers, test engineers, project managers, and even business users can use the advanced search with JQL to find the need-to-know information. JQL, or Jira Query Language, is a powerful what are JQL queries and how to use them tool that allows teams to easily search and filter issues within Jira. It is a simple yet powerful language that allows users to search for issues based on various criteria, such as issue type, status, assignee, and more. JQL, or Jira Query Language, is a powerful tool for creating advanced search queries in Jira.

The most simple search feature in Jira is the search box at the top right of your screen. Functions give the user power to manage the JIRA issues in an easy way. Note, that the “in” keyword will include any item which matches any item in the list. JQL functions are a very handy way to ask Jira to look up real-time information on your behalf. Let’s dive into the key ingredients of an iron-clad JQL search query. The following video explains JQL functions and how to use them in Advanced JIRA queries.

This query will find all issues in the « Acme Project » that are currently in the « In Progress » status. This blog is intended to be a tutorial for those who have no experience with database queries or SQL queries to those who want faster access to information in Jira. So much so that other Jira-based software use it for other purposes. Our PPM software, BigPicture, unleashes the power of JQL in reporting, configuration, and visualization. You might use certain searches regularly, so it would be great if Jira remembered the parameters of your JQL search. To simplify this definition, think of keywords as words or phrases that provide additional conditions to your search.