Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

What JQL filter syntax is best for a couple of conditions?

Phil Bustin
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 Champions.
May 19, 2023

I have the following working Filter, but I'd like to know if there is a better way to specify multiple statuses; a status with parentheses in its name, and the condition [date field] = today. 

I thought there might be a more compact construct for the IN condition than the one I used, and a less arcane syntax for the date field = today condition than -0d.   

In order to get the filter to work, I changed the name of the status containing parentheses from "Approval (PR Tasks)" to "Approval - PR Tasks".

Working filter

project in (TAST6, PIN, "INT") AND issuetype = "Dev Story" AND (status = "Waiting for PR Move" or status = "Selecting PR Tasks" or status = "Approval - PR Tasks") AND "PR Move Req Date" = -0d order by "Create Date" ASC

 

1 answer

0 votes
miikhy
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 Champions.
June 27, 2018

Hi Maria!

Natively I don't think you can have a real hierarchical view but if you're OK to bring some third parties, Structures for Jira is definitely great at that, you can try it out here:

https://marketplace.atlassian.com/apps/34717/structure-for-jira-projects-at-scale?hosting=server&tab=overview

Hope this helps!

Cheers

Mari Car
Contributor
June 28, 2018

thank you, that is what I need, but unfortunally not for cloud ! 

miikhy
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 Champions.
June 28, 2018

Oh Cloud :(

Have you considered Portfolio? It's giving far more than just that view and Atlassian put a great focus on it!

Cheers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events