Advanced JQL Filter

[Kristen Viscardi]

Hi I am trying to create a filter so if any issues in my project sit in the resolved state for more than 3 days, they automatically transition to closed. Can someone please help me with this?

Thanks!

[Sergio Betterelli _ACP-JA _ ACP-JSW_ __ · Accepted solution]

Hi Kristen,

Here you go :

First test if all the issue in your project has been resolved with a resolution:

Paste this in Issues> Search for issues Section: 

project = XXX  and resolutiondate is not null  and resolution is null and status = resolved

Zero issues is normal.

Then we can setup the rule in the automation Plugin

In the section select trigger > JQL filter Trigger

In the cron section: paste this for example if you want close all issue in resolved status, at 7.15 am every day

0 15 7 * * ?

Then paste the JQL code:

project = XXX and resolutiondate < -3d and status =resolved

(remember to change XXX with the key of your project)

Then in the next section Add Section

Set Choose Section > Transition Section

Then set the exact close  transition (this is relative to your project's workflow). Start writing clos.. and then choose the correct one.

You can also check: Disable notification for this transition?

Then click next, save.

Hope you find it usefull,

Thanks

Sergio

[vitaliy zapolskyy]

it can be implemented using com.onresolve.jira.groovy.GroovyService

Please find an example here: https://scriptrunner.adaptavist.com/latest/jira/services.html

[Kristen Viscardi]

I'm trying to use the JIRA automation plugin

[Carla Ann Rowland]

Hi @Kristen Viscardi

There are settings at JIRA Admin to set final resoution.

Check the automation on left sidebar. Those are global settings. If you need project you can make it a post function on the workflow for that project. 

Hope this helps.

[Doug Swartz]

It might be helpful if you tell us what tool or approach you're using to implement the auto-close.

Assuming your final status is "Closed" a query something like this should give you the list you're looking for:

resolutiondate < -3d and status != Closed

[Kristen Viscardi]

I'm trying to use the JIRA automation plugin