JQL for JIRA tickets 7 years from CLOSED date.

Question

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

Leo Diaz - Deiser · Answer

Hi! you can try

status = Closed AND updatedDate <= -2555d

Peter DeWitt · Answer

@Scott McDonald, try createdDate <= -2555d

Scott McDonald_qykakt · Answer

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