JQL to filter tickets that are status To Do + In Progress + (Done less than 30 days)

Jonathan Walder

Hi everyone,

I am trying to create a filter to show me all tickets that have (Status = To Do OR Status = In Progress) which works fine but also want to view tickets that are Status = Done only showing the Done tickets if they have been Done for 30 days or less. Once the ticket has been Done for 31 or more days it should not appear in the filter. Any idea how to do this?

I tried (status = "To Do" OR status = "In Progress") AND (status = "Done" AND resolutiondate <= 30d) but cannot get any results.

robert.nadon

With the AND it will never show

(Status = To Do OR Status = In Progress) OR (status = "Done" AND resolutiondate <= 30d)

Or you could:

(Status = To Do OR Status = In Progress) OR (status = "Done" AND Status Changed to "Done" AFTER "-1m")

The big problem you have above is it should not be an AND because the status cannot be either in todo or in progress and in Done a status can only be in one state at a time.