Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Jacob
Contributor
October 9, 2023

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.

 

2 answers

1 vote
Judd Garratt - Path of Trees
Atlassian Partner
October 9, 2023

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 Champion
October 9, 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
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events