JQL query to update field after 7 days (Jira server)

[Edgar Pusklevic]

Hi everyone ,
situation: I'm doing automation for project , and I need that every task with status Ready  should change to status Done after 7 days last update.

status=Ready and 'Updated' > '7d'

status = Ready working , also he should check field Updated  , and if it's older than 7 days , automation should change status to Done.

[Edgar Pusklevic · Accepted solution]

thanks for all. working rule is here:

[Rilwan Ahmed]

Hi @Edgar Pusklevic ,

Create a automation using "Scheduled" trigger (example: Run daily at 01:00 AM) and below JQL in the conditions. 
status = Ready AND updated < startOfDay("-7d")

[Edgar Pusklevic]

thanks for all , working config is in photo.

[Rilwan Ahmed]

Hi @Edgar Pusklevic ,

Please accept the answers which helped you. Users with similar query will find it useful

[Gokaraju gopi]

@Edgar Pusklevic 

You need to schedule an automation.

[Tharaka_Hettiarachchi]

Hi @Edgar Pusklevic ,

you can create a automation like this

1. Create a 'Scheduled' trigger which will run everyday at a given time

2. Create 'New Condition' -> 'If / Else' 

Check your conditions

- Status in 'Ready' & check that the issue has updated more than 7 days 

3. Then transition your task to 'DONE'

Cheers!

[Fabio Racobaldo _Herzum_]

Hi @Edgar Pusklevic ,

please try the following JQL :

status changed TO "Ready " BEFORE startOfDay(-7)

Hope this helps,

Fabio