You can also search issues from the “Issues” section in the dropdown menu. Checks if the Employee object has an attribute Office whose value is NOT equal to Stockholm. Give your filter a meaningful name so you can easily identify it later. This guide will be incomplete without the mention of Jira service management. Detailed documentation about the keywords can be looked at here. This detailed guide about JQL or Jira Query Language will set you on the path to success with sufficient breadth & depth of knowledge.

• These features help you get more out of the tool than to write the same queries repetitively.
• One of the reasons why Jira is so popular within the software development sphere is the JQL.
• Thanks for sharing this article @Andrei Pisklenov _Actonic_ !
• When a query has to search through fewer issues, results load faster.
• 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”.

The “CHANGED” operator is used to find issues that have a value that had changed for the specified field. The “WAS NOT” operator is used to find issues that have never had the specified value for the specified field. This is extremely helpful for organizations that have service level agreements (SLA) with their customer base.

Operators

Here’s a handy tip – use parentheses to group related elements together. Simple, check the entire query below & notice how we have added the OR keyword, used brackets to combine two seemingly different criteria together. When you have hundreds of columns and tens of thousands of rows, it’s much easier jql query to use a database to store information and use Structured Query Language (SQL) to access the data. You can even create custom software that runs SQL queries to retrieve data and presents the information in intuitive ways. When a query has to search through fewer issues, results load faster.

Well, now if your JQL is complex it will say something like ‘This JQL query is complex & cannot be converted into a basic search’. For example, the default priority field has possible values of Blocker, Critical, Major, Minor, Trivial. Similarly, assignee field will have the users as possible values. Well, as it turns out – the above logic also applies to the popular project management tool, Atlassian Jira.

More in Jira

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 that are at least one day old. Filter objects based on the object type specified by the ID and its children. Filter objects based on the object type specified by the Name and its children. If the name contains spaces, make sure you enclose it within a pair of double quotes.

Will return objects which have outbound  referenced objects of Employees and only for those Employees objects whose Reference Type is “Location”. Will return objects which have inbound referenced objects of “File System” and only for those File System objects whose Reference Type is “Depends”. The dot operator here navigates to the referenced object Office in the attribute Country and compares Office with the value Stockholm. Instead of the objectId, you can always use the Key attribute on any object type to search for a particular object. You can limit the search to the object, e.g. “object having inboundReferences()” will search all objects having any inbound references to it. This basic AQL query would return all objects for which the Owner is “Ted Anderson”.

Functions in Jira Query Language

Will return information based upon objects referenced by the parent object. Our verdict – AI or not, the need to learn Jira Query Language will remain in demand. If not for building complex queries but for verifying them, when generated through AI. Are trying to end bad service management with Atlassian tools?

JQL, short for Jira Query Language, is the preeminent and exceptionally versatile method for locating issues within the Jira platform. JQL caters to a diverse user base, encompassing developers, testers, agile project managers, and business stakeholders. Its utility extends beyond mere issue retrieval; a proficient mastery of JQL empowers users to conduct nuanced searches and queries of Jira issues.

What is JQL?

Note the quotations around “Ted Anderson”, since there is a space in the value name. AQL can be used in the Advanced AQL search, or within an Assets object custom field. Do thought experiments & try to guess what a Scrum master might ask from you as opposed to a project manager who is managing 3 different projects. This list does not end here, but it should definitely give you an idea into the depth of function availability for advanced search in Jira. Tip – One easy way to see the limitations of basic search is to try & switch to the Basic search from JQL search. Remember how Jira itself converted basic search into the JQL query?

First, you should break down your complex query into several individual query conditions. Start by writing the JQL for each query condition separately, and then try combining them together. To perform a more complex query, you can link clauses together with keywords. @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.

Reference functions

These features help you get more out of the tool than to write the same queries repetitively. We also discussed the importance of using parentheses for complex queries and leveraging functions to enhance your jql queries further. Having a JQL cheat sheet can be incredibly helpful for quick references. Download our comprehensive PDF cheat sheet below and keep it handy.

This function will only work when an issue is selected, and refers to the reporter that appears in the current issue. You can use a range of functions to write queries which involve date and time. You may use operators such as AND/OR to create larger and more complex AQL expressions. Excludes values which match with any subset of input in the query.

Select all issues you are interested in

So more often than not, you will work with your colleagues in there. That’s where the workload of creating various JQL queries can be distributed amongst the team. Filter objects having outbound references where the referenced objects match the AQL query provided as an argument to the function. You can filter on user attributes connected to current reporter in custom fields by invoking this function in your AQL query.