jql query

Suma Pralhad Kustagi May 18, 2021

Hi,

    Can you please suggest a better way for writing a jql query..

Have certain condition that for one issuetype(Story) it should show status done,open and for the other issue type in bug,Change Request it should show the status with INPROGRESS,VERIFY etc... If I mention OR condition it takes only one suitable and displays one result only. But I need to achieve in query with OR condition.

 

Do we need to create two seperate boards??

How to achieve in one single query and for one board.

 

Regards,
Suma

 

 

1 answer

1 accepted

4 votes
Answer accepted
Suprija Sirikonda _Appfire_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 18, 2021

Hi @Suma Pralhad Kustagi ,

To get issues of different issuetype and specific status for each issuetype, you can use combination of AND, OR and parentheses : 

(issuetype = Story AND status in (Done, Open)) OR (issuetype in (Bug,"Change Request") AND status in ("IN PROGRESS",VERIFY))

Hope this helps!

Regards,

Suprija 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events