Getting Smart With JIRA Query Language
Posted By : Himani Sharma | 23-Nov-2017
JIRA Query Language (JQL) is the alternative and most flexible way of searching the issues in JIRA which can be used by the technical as well as non technical business user. JQL is a part of advanced search though there are different filters that comes under the Basic search but the search result using JQL is more specific and refined.
Let us take an example if someone wants to see the list of all the reopened bugs from the start of the sprint till date in the name of one person. However we can search the same using Basic search by checking the checkbox of the status “Reopened” but what if the the status of that bug has been changed by the Developer as Resolved and tester Closed that bug after testing. Now you will never able to get the total number of Reopened bugs as the status of these bugs is no longer remains Reopened.
Let us start with JQL:
1.) On Jira Dashboard go to Issues in Header
2.) Select ‘Search for issues” in the list
3.) Click on the “Advanced” Link on the page
Let’s start with simple queries:
1.) project = Test AND status was Reopened
Explaination : In this query we have used project keyword to select the project which is Test here and “=” is the operator, we can use other operators are as well like <, !=, etc . Keywords are the predefined words having specific meaning in any language.
With the help of this query we would be able to find all the reoped issues under Eimars project.
2.) project = Test AND status was Reopened AFTER "2017/09/25"
Explaination : In this query we are using AFTER keyword to filter all reoped issues after a speficic date, we can also use BEFORE keyword as per our requirement.
3.) project = Test AND assignee= amit.shah
Explaination : With this query user can easily find all the issues in the name of assignee “Amit Shah”.
Cookies are important to the proper functioning of a site. To improve your experience, we use cookies to remember log-in details and provide secure log-in, collect statistics to optimize site functionality, and deliver content tailored to your interests. Click Agree and Proceed to accept cookies and go directly to the site or click on View Cookie Settings to see detailed descriptions of the types of cookies and choose whether to accept certain cookies while on the site.
About Author
Himani Sharma
Himani brings years of experience as a Quality Analyst, demonstrating expertise across the entire Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), and Agile Methodology. Her skill set includes Release Planning, Risk Analysis, Test Planning, Estimation, and Reporting. Himani is proficient in Manual Testing for both web and mobile applications, Configuration Testing, as well as Load Testing using JMeter. She has successfully led teams in client projects. She is well-versed in bug reporting tools such as JIRA, Trello, Mantis, and Bugzilla. She has extensive experience in API Testing using Insomnia and Postman. Additionally, Himani is skilled in using debugging tools like Charles Proxy, as well as other tools like TestRail and Confluence. Her valuable contributions can be seen in client projects such as Pesamill, Belfrics, Coinzoom, ERM, Wethio, and HUMA.