SQL to automatically close ticket after 7 days

[Sergio Yelamos Jimenez]

Hi everyone,

I want to set up a Jira automation rule when i resolve one ticket and after 7 days, the ticket is not updated, close it automatically.

Can somebody help me with this?

Thanks and regards!

[Walter Buggenhout · Accepted solution]

Hi @Sergio Yelamos Jimenez and welcome to the community,

Something like this should do what you are looking for:

I used a combination of search on current status and what the status was more than 7 days ago to trigger the rule. You can find a good article on history searches right here if you want to learn more.

Hope this helps!

[Sergio Yelamos Jimenez]

Hi Walter, 

Thank you for that! I'm a new member in the Atlassian community :)

That would work for me i will try but there are some customers that comment in the ticket and leave the ticket Resolved. I would need something like status = Resolved and not updated before -7d.

Do you know how can i build that JQL?

Thanks and Regards!

[Walter Buggenhout]

Yes, it is on the screenshot I shared:

status = resolved and status was resolved before -7d