Need to create a queue that contains all tickets untouched over 90 days

[Alison Files]

I am trying to create a queue that lists all open tickets that have not been touched in 90 days.  The queue must not contain tickets that have a status of done, resolved and canceled.  I have the following so far, but I don't know how to add more than one status.  status != resolved AND updatedDate < -90d AND summary !~ Terminations ORDER BY createdDate ASC, updatedDate ASC   This works to keep resolved tickets out of the queue, but I am still seeing canceled and done.

Any help would be appreciated!

Thanks,

Alison

[Trudy Claspill · Accepted solution]

Hello @Alison Files 

Instead of using = or != to compare Status to a single value use IN or NOT IN to compare Status to a list of possible values.

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#NOT-IN

status not in (<comma separated list of status values>)

status not in (resolved, done, canceled)

[Alison Files]

Thank you, Trudy - that worked!  Much appreciate the response!

Alison