JQL is the most popular way to search history in Jira, but it has some limitations. It provides you with a bunch of filters and customizable report where you can add/remove columns to get only changes for the fields you need. Try using the updatedBy() function to search for the issues that have been updated by a certain user. It will show any issue field’s changes, creating an issue, creating/editing/deleting a comment. A month into the process, we built a prototype that embedded the V8 JavaScript engine into Arb.
For example, you can search for issues that have a specific label, multiple labels, or even exclude certain labels from your search results. In this chapter, we will explore jira query language the basics of JQL and learn how to perform simple issue searches in Jira. Simple issue searches allow you to quickly find and filter issues based on specific criteria.
9.9 Stay Up to Date with Jira Updates
In simple terms, it’s a saved search query you can reuse instead of writing it from scratch every time you need it. To make finding specific information easier, Jira allows its users to view the filters in a dashboard. With Jira Query Language, you can find a list of issues based on their values at a particular point in the past, instead of the current value of those fields.
Advanced searches with JQL don’t work for all fields and have some limitations. Next, we added some features to make it easier to do common tasks. For instance, groupByallows you to segment your data and groupByUser allows you to analyze each user’s activity history. Segmentation and per-user activity histories are the building block of most engagement analytics.
An easy way to write a JQL
What if you need to look for historical modifications that JQL is unable to support? It may include sprints, issue kinds, descriptions, comments, deadline dates, or other updates. The plugin serves as a history log for all previous activity at the issue level. With all past changes listed in diary format in chronological order, it’s easy to see all updates.
- In this query, we are searching for issues reported by John Doe and assigned to Jane Doe.
- Custom fields, in particular, provide flexibility for capturing specialized information relevant to your projects and workflows.
- This documentation will not only help you remember your queries but also enable you to share them with your team, fostering collaboration and knowledge sharing.
- Therefore, it’s essential to familiarize yourself with the issue types available in your Jira instance before constructing JQL queries based on issue types.
Jira Query Language (JQL) is a powerful and flexible search language used in Jira Cloud to retrieve and filter issues based on specific criteria. It allows users to perform advanced searches and create custom filters to find the information they need quickly and efficiently. JQL is a fundamental tool for Jira users, enabling them to navigate through large datasets and locate relevant issues with ease.
4.3 Mathematical Operators
Remember to start with simple queries, understand your data model, and utilize the right operators, functions, and keywords. Test and refine your queries, document them for future reference, and stay informed about Jira updates. With these practices in place, you’ll be well-equipped to master the art of JQL and streamline your Jira workflows. JQL operators are an essential component of the Jira Query Language (JQL) that allow you to perform specific actions and comparisons in your search queries. By understanding and utilizing these operators effectively, you can refine your searches and retrieve the precise information you need from your Jira issues. And if you’ve ever created custom fields, you can also use them in advanced searches.
Maintain a repository or a document where you can store your queries along with their descriptions and use cases. This documentation will not only help you remember your queries but also enable you to share them with your team, fostering collaboration and knowledge sharing. The functionName is the name of the function you want to use, and the arguments are the parameters or values that the function requires. 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.
Examples of a JQL query
Find issues where the status changed from In Progress to Done after some date. By following these best practices, you can leverage JQL functions effectively and unlock the full potential of Jira’s querying capabilities. In this example, the dateCompare function is used to subtract 7 days from the current date, and the createdDate field is compared against the result. Creating custom functions requires some programming knowledge, but it opens up a world of possibilities for extending Jira’s functionality. You can create functions to calculate custom metrics, generate reports, or automate workflows. The flexibility of custom functions allows you to tailor Jira to your unique requirements.
Understanding the syntax of JQL is essential for effectively searching and filtering issues in Jira. In this section, we covered the keywords, operators, field names, field values, and functions that make up the JQL syntax. By mastering these elements, you will be able to construct complex queries to retrieve the exact information you need from your Jira instance.
Text searches with JQL
This knowledge will help you construct more accurate and efficient queries. Take the time to explore your Jira instance and identify the relevant fields and their values. The advanced search provides an autocomplete feature that allows you to craft queries using JQL. Any basic search can be translated into a JQL query by switching to the Advanced mode from the Basic mode.
In this query, we are searching for issues reported by John Doe and assigned to Jane Doe. By using the AND operator, you can specify multiple criteria that must be met. Replace “username” with the username of the reporter you want to search for.
For example, BigPicture contains an extension called Enhanced JQL. Each field provides a different piece of information to its users. The most popular examples of fields include status, assignee, and priority.
