JQL filter for automation has not been updated within last 2 working days

Question

Hi,

I want a JQL filter that returns all tickets that have not been updated in the last 2 working days.

Example.

On a Mon I want to see all tickets that were not updated Thu, Fri, Sat, or Sun.

On a Tue I want to see all tickets that were not updated Fri, Sat, Sun, or Mon.

On a Wed I want to see all tickets that are not updated Mon or Tue.

On a Thu I want to see all tickets that are not updated Tue or Wed.

On a Fri I want to see all tickets that are not updated Wed or Thu.

Sanjog Sigdel · Answer

Hello @Jacob

I've one Jira Filter Subscription:-

Filter for Tickets in PO Review and not updated for last two days

My JQL is:-

Sprint in openSprints() and status in("Product Owner Review") and updatedDate <= -2d

Since your requirement is only tickets not updated for last two days you can only use the updatedDate <= -2d to get the ticket results

Then you can add a Jira Filters Subscription to trigger the email notification. You won't require a automation to do so.

Manage subscription and schedule email as per your necessity:

Judd Garratt - Path of Trees · Answer

Hi Jacob,

@Phill Fox has some great solutions for pulling issues from the last two days (excluding weekends) in this post. His approach will likely work well for your case also :)