JQL allows teams to easily find the issues they need, improving productivity and efficiency. Understanding linked issues is also important when you’re prioritizing tasks. You want to make sure that a high priority issue isn’t being blocked by another issue that might be set as a lower priority. To check on that, the query you need to use is different in the cloud and data center versions, so make sure you use the right one.

While there are built-in reducer methods to address common use cases, a reducer function is flexible and can be used to aggregate inputs into a single value. For example, returning the earliest timestamp and latest timestamp could be done using a reducer function. Using the above JQL query you can return all issues that have not been assigned to anyone. Jira fields contain information of an issue in the system. The most common Jira fields are sprint, priority, labels, issuetype, status , and so on.

When to Use Jira Filters and Jira Query Language (JQL)

For example, you could use groupBy() and this reducer to implement Mixpanel’s Segmentation report. An accessor can be a JavaScript function, a string with a dot-separated property path, or a built-in mapper function, like mixpanel.numeric_bucket(). The second aggregation instructs JQL to strip off position 0 of the key holding the distinct_id, and aggregate again, counting results up.

This allows teams to easily share queries and search results with others, improving communication and collaboration. The following function provides lists of versions that match the provided regular expression. Performance is proportional to the number of issues selected by the subquery, so use the query that selects the smallest set of issues you can.

mixpanel.reducer.null()

And if you’ve ever created custom fields, you can also use them in advanced searches. If your Jira instance is filled to the brim with projects, issue types, or assignees, finding specific information quickly can be challenging. Fortunately, Atlassian’s tool comes with various search capabilities. The one that stands out is called Jira Query Language (JQL). It’s a highly competent tool that makes finding a needle in a data haystack much easier. JQL full form is Jira Query Language is used to search your issues in Jira.

Both of them will help you aggregate your issue data and filter through the information to find what’s important to you in Jira. DEMO-1 is returned by the query above as it has “is blocked by” links from DEMO-2 and DEMO-3. An operator resides between a field on the left and one or more values on its right. Then, the operator compares the value and only true results are returned.

Keyword

JQL offers search functionality for a value in a specific field. The use of parentheses is recommended in complex JQL queries to enforce the precedence among the operators used. Enabling each of them to easily create custom queries to suit their specific needs. This query will find all issues created within the last 7 days.

• This transformation is a specialization of groupBy() that guarantees that the reduce function(s) will process all events of a single user in temporal order.
• A simple query in JQL is known as a “clause” and it consists of a field, followed by an operator, followed by one or more values or functions.
• CommitId filter is an optional parameter for all queries.
• Internally, Javers generates Initial Changes by comparing a virtual, totally empty object
  with a real NewObject.
• If you have several custom fields with the same name, you must use the custom field ID.
• Flatten the collection by inlining array elements of the input collection.

This will show you all the issues that person took action on and what follow-up might be needed. Read on to learn some of the most common queries for project managers and how to use them. 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.

While the out-of-the-box features offer many possibilities, apps like ScriptRunner provide additional functionalities for more targeted queries. By combining the right functions and understanding the JQL syntax, you can efficiently manage and navigate your Jira instance to get the most out of it. Hopefully, you now know enough about Jira Query Language (JQL) to start writing your own queries. Compared to the basic search, this filtering method is in a league of its own. And when you add filters to the mix, regular verification of crucial project data will be a breeze.

Providing an empty string (e.g. “”) causes the query to match each issue in your Jira instance, making your query very inefficient. Functions can be customised in what are JQL queries and how to use them many ways, and search a variety of fields in Jira. Make a request to the Jira Cloud REST API to see all fields you can use inside of the function expressions.