nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation send email with issues based on last update

Mariano_93cg92

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!

Accepted answers

Alexis Robert

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

All comments

Alexis Robert

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

Mariano_93cg92

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

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

Mariano_93cg92

@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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management