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”.

Related Tags

About Author

Author Image
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.

Request for Proposal

Name is required

Comment is required

Sending message..