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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Automation send email with issues based on last update

Hello! I couldn't find previous threads explaining exactly what I need, and Google also wasn't of help :/

 

I am looking to create an automation rule that checks daily for issues that nothing changed in two days (no update, no status change, etc) and send me an email letting me know it didn't change for two days.

I did add a rule to email me when this JQL is true: project = "My Project" and status = "Waiting for support" and updated >= 2d

the updated >= 2d part I tried it in all imaginable ways, updated <= -2d, updated >= -2d, etc etc. None of them worked.

 

 

On the other hand, I also need a rule that when a ticket is just open, and no action has been taken for 4 hours, to shoot me an email as well.

Not for being lazy, but since I can't seem to grasp the concept of time comparison on JQL, I am weary to try any rule because it just won't work :'-(

 

Thanks in advance for any assistance!

1 answer

1 accepted

2 votes
Answer accepted
Alexis Robert Community Leader Jun 16, 2021

Hi @Mariano , 

 

correct JQL would be "updated <= -2d" : this will show issues that were updated more than 2 days ago.

The same JQL for "no action for the last 4 hours" is "updated <= -4h".

 

Let me know if this helps, 

 

--Alexis

Hello @Alexis Robert ! Sorry for the late reply.

For the sake of spreading my scope and see if it triggers an email, I did the following:

project = "My Project" and status = "Waiting for support" OR status = "Open" and updated <= -2d

 

Am I doing something extremely wrong or should I consider retiring from trying to admin Jira? 😂

 

Maybe there's something wrong with the way the project or issues are setup? It's a simple Service Desk project though, nothing too fancy.

Alexis Robert Community Leader Jun 25, 2021

Hi @Mariano , 

 

this might be because of the way you're writing your query with the OR statements. Can you try this : 

 

project = "My Project" and ( status = "Waiting for support" OR status = "Open" ) and updated <= -2d

 

Thanks, 

 

Alexis

@Alexis Robert you're a genius thank you! One last question and I promise I won't bother anymore :)

Is there a way to avoid Jira emailing me on weekends?

Maybe a Today() != clause of some sorts? I am kinda sad you cannot mix JQL with the Jira easy search formatting.

Alexis Robert Community Leader Jun 28, 2021

Hi @Mariano ,

 

if you're using the Scheduled trigger in Automation, I believe you can do something like this : 

 

Screenshot 2021-06-28 at 09.52.20.png

 

 

Let me know if this helps, 

 

--Alexis

Like Mariano likes this

This is genius @Alexis Robert !, exactly what I was looking for.! Thank you so much and have a nice day!

Ah, but this is for the weeekly one. I was looking more into the rule running hourly, but not on weekends. I guess you can't have it all! lol

 

But thanks anyway for all the help, at least I got my rules working and it helps a lot with work!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Atlympic Event: Jira Service Managemnt

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

99 views 0 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you