Forums

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

JQL for JIRA tickets 7 years from CLOSED date.

Scott McDonald
Contributor
March 1, 2018

Hello:

We are going to  need to implement a deletion process for JIRA tickets. I have received approval to have all JIRA tickets deleted 7 years from CLOSED date.  I feel like I'm half way home with the following query but just can't get across the finish line:

status changed to Closed after -2556d

I will then implement this as an automation rule but first I need assistance in the actual JQL.


Thank you,

Scott

2 answers

0 votes
Peter DeWitt
Community Champion
March 1, 2018

@Scott McDonald, try createdDate <= -2555d

0 votes
Leo Diaz - Deiser
Community Champion
March 1, 2018

Hi @Scott McDonald

Try this JQL:

status = Closed AND updatedDate <= 2010-12-31
Scott McDonald
Contributor
March 1, 2018

Thank you. Is there a way to make that updatedDate dynamic?  I would like to have this rule run everyday.

Leo Diaz - Deiser
Community Champion
March 1, 2018

Hi! you can try

status = Closed AND updatedDate <= -2555d  

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events