Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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



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


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.


2 answers

1 vote
Judd Garratt - Path of Trees
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Oct 09, 2023 • edited

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 :)

0 votes
Sanjog Sigdel
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 09, 2023

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:

Screenshot from 2023-10-10 11-28-50.png

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events