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

Phil Bustin_7fmhjs

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

 

Trudy P Claspill

Hello @Phil Bustin 

For multiple status values use the IN operator. Example:

status in ("Waiting for PR Move", "Selecting PR Tasks")

 

If the statuses you want to check all belong to the same Status Category, and you want all statuses that are in that Status Category, then you could use the Status Category instead. Example: to get all issues that have a blue status (which is a status that is a member of the "In Progress" Status Category)

statusCategory = "In Progress"

 

To search for a status that has parentheses in the name simply enclose the status name in quotes.

status in ("status (with parens)")

To check for a date field against the current date you can use startOfDay(). Example

"PR Move Req Date" > startOfDay()