We would like to find out the tickets which are in particular status and were not updated for the last 3 days.
Lets say Tickets in 'In Review' for the last 3 days (excluding weekends). We would like to send an email alert to PM's if the ticket status was in "In Review" for the last 3 days.
Thanks in Advance.
Regards
Madhu
Hi @Madhu Mullangi ,
Unfortunately, what you are looking for is not possible with the built-in functionalities of JQL. Because JQL can not make calculations and you need status time calculation excluding weekends.
For this exact need we developed Status Time Jira app. It provides reports on how much time passed in each status. You can also export the report as CSV and open it in excel.
Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.
Here is the online demo link, you can see it in action and try without installing the app.
If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.
How about:
status=Review and status changed BEFORE 3d and updated<-3d
Hi @Madhu Mullangi ,
Is
updated >-3 OR (updated > -5d AND updated > startofWeek(-3d) AND updated < startofweek())
an option?
This is a answer from @Phill Fox in https://community.atlassian.com/t5/Jira-questions/Need-filter-for-tickets-not-updated-for-last-3-days-excluding/qaq-p/1437566
I think automation can helps you
Recommended Learning For You
Level up your skills with Atlassian learning
Learning Path
Jira Software Fundamentals
New to Jira Software? These short, self-paced courses will teach you what you need to know to get up and running quickly.
The Beginner's Guide to Agile in Jira
Learn what agile, kanban, and scrum are and how agile works in Jira Software.
Realizing the Power of Jira Reporting and Dashboards
Use out-of-the box reporting and dashboard capabilities to view and assess progress and bottlenecks within projects.