Automation for Days in Work

[SHEHZADALI ISMAILY]

How can i create an automation rule that will alert me via email or teams notification when a 3 points story sits in an in progress status for more than 3 days?

A supporting screenshot of the automation rule would be helpful as well.

Thank you

[Birkan Yildiz _OBSS_]

Hello @SHEHZADALI ISMAILY 

Yes, you can use Jira's built-in Automation. But there is another option if you are open: A marketplace app.

If you'd prefer a single, consolidated report of all stuck issues instead of individual alerts, you can use a dedicated reporting app. Timepiece - Time in Status for Jira is designed for exactly this.

The process is straightforward. First, you create a report using JQL to find all issues with 3 or more story points.

 

Then, you use Timepiece's own filters to narrow that list down to only the issues that have been "In Progress" for more than 3 days.

Finally, using the 'Scheduled Reports & Alarms' feature, you can have this report automatically sent to your email, MS Teams, or Slack at any frequency you choose, like every hour or every morning at 9 AM. It can be configured to only send the report if it finds matching issues, so you won't receive empty notifications. So, you can use Timepiece as your early warning system and only jump in if you truly have to.

This gives you a single, actionable report of all bottlenecks instead of a stream of separate alerts.

Hope that helps. Please let me know if you have any further questions.

Disclaimer: I am a part of OBSS, developer of Timepiece.

[Benjamin Črnjak]

Hi @SHEHZADALI ISMAILY

I would say JQL is the 🗝️ for your solution. You could use either scheduled automation with JQL filter that will notify you using custom email. Or you could go with @Bill Sheboy approach using filter subscription.

In my opinio, filter subscription is a better option as it won't consume any automations, furthermore you will get a list of work items in a single mail which is very handy 😊.

Hope this helps.

Regards,

Benjamin

[Bill Sheboy]

Hi @SHEHZADALI ISMAILY 

First thing, as a reminder: the Atlassian Community is a place for people to collaborate and learn from one another.  It is not a place to provide turnkey solutions upon request.  When you regularly need help with automation rules, please work with your Jira Site Admin to learn more about now to create and use automation.

To learn more, please review the community guidelines.

And thus, if you have started a rule and it is not working as expected, please post images of your rule, the audit log, and explain what is not working.  That will provide context for the community to offer suggestions.

An alternative solution would be using a saved JQL filter, and to subscribe to the filter to receive daily updates by email.

Such a filter could use the JQL CHANGED operator: https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED

For example:

project = myProject
 AND status = "In Progress"
 AND NOT status CHANGED AFTER -3d
 ORDER BY Key ASC

Kind regards,
Bill

[SHEHZADALI ISMAILY]

This comment came off as hostile, rude and unprofessional.

I have created numerous automations and only posted for help in those cases where I have exhausted all other efforts.... speaking with fellow colleagues, JIRA admins, ChatGPT, old school google searches, etc.

People within this community are at various levels of maturity when it comes to comfort level and expertise in using Atlassian's tools, and we should be considerate of that.

I think that should be taken into consideration and some empathy shown.