Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,465,762
Community Members
 
Community Events
176
Community Groups

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

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.

 

6 answers

1 accepted

0 votes
Answer accepted

thanks for all. working rule is here:

ready-Done.png

1 vote
Rilwan Ahmed Community Leader Dec 12, 2022

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")

image.png

thanks for all , working config is in photo.

Rilwan Ahmed Community Leader Dec 15, 2022

Hi @Edgar Pusklevic ,

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

0 votes

@Edgar Pusklevic 

You need to schedule an automation.

at15.JPGat16.JPG

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 

Screenshot 2022-12-12 at 14.01.08.png

3. Then transition your task to 'DONE'

 

Cheers!

0 votes

Hi @Edgar Pusklevic ,

please try the following JQL :

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

Hope this helps,

Fabio

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events