"JQL Query for Detecting 'In Progress' Status Unchanged for 3 Days with Email Notification in Projec

[Arief Ramadhan Heldian]

Tell me how to create a JQL query for when the status is "In Progress" and it hasn't changed for 3 days, so an email is sent. The project name is LGLN.

[GNarsimhagowda - Empyra · Accepted solution]

Hi,

The query you are looking for is 

project = LGLN AND status = "In Progress" AND updated <= "-3d" ORDER BY updated DESC 

Will give you the result that issues which are not updated in the last  3 days which are in "in progress status" . To send an email you can use automation and send the emails to the required recepients.

Thank you.

[Arief Ramadhan Heldian]

And what about the calculation for these 3 days, does it not follow or is it different from the SLA ? @GNarsimhagowda - Empyra 

[GNarsimhagowda - Empyra]

Hi @Arief Ramadhan Heldian ,

It follows the SLA that you have configured in the project.

Thank you.

[Arief Ramadhan Heldian]

Thank you @GNarsimhagowda - Empyra