Filtering for Stale Tickets over the Weekend

[Creighton Donovan]

I'm trying to filter for tickets for which their last update was greater than 2 days ago, but not counting Saturday and Sunday.  I know that this is generally an SLA breach solution, but I'm doing it the JQL filter way because of how we have SLAs set up and also for my own education. 

I've seen this post, https://community.atlassian.com/t5/Jira-questions/Need-filter-for-tickets-not-updated-for-last-3-days-excluding/qaq-p/1437566 which is similar, but my amateur experience can't get it to work.

This line gets me the overarching idea:

• AND NOT updated >= -2d

but I don't know how to stack conditions to exclude Saturday and Sunday from the -2d.

Any help?

[John Funk · Accepted solution]

Hi Creighton - Welcome to the Atlassian Community!

Try this:

updated > -2d OR (updated > -5d AND updated > startofWeek(-3d) AND updated < startofweek(1d))

[Creighton Donovan]

Hi John,

Thanks for chiming in, I really appreciate it.

The first part of that,

• updated > -2d

That returns results that have been updated more recently than 2 days in the past, right?  I'm looking for the inverse, results that haven't been updated in the most recent 2 days.

[John Funk]

Sorry switched the signs

updated < -2d OR (updated > -5d AND updated > startofWeek(-3d) AND updated < startofweek(1d))

[Creighton Donovan]

Something's still not working correctly, apologies that I don't have better diagnosis than that.

What I get from running the filter is all tickets opened in the last 30 days (my test filter starts with created >= -30d) EXCEPT two created today. I checked and there were tickets updated on Friday, Saturday, and Sunday, but they are still coming through on the filter results as false positives.

[John Funk]

updated < -2d OR (updated > -5d AND not updated > startofWeek(-3d) AND not updated < startofweek(1d))

[Creighton Donovan]

Thanks for sticking with it @John Funk I couldn't keep the NOTs, greater thans and less thans straight on my own.

Really appreciated!