Anyone can suggest me a jql filter for tickets in a particular status with not "status changed" for last 3 days excluding weekends? I found some thread with same problem but for "updated". Status changed can accept just "after" and "before" instead of "<>". Thanks
Hi @Ambrosino Salvatore
You can use "NOT Status Changed AFTER" in your JQL query.
For example:
project=YOUR_PROJECT_KEY AND((not status CHANGED DURING ("-3d", now()) AND not status CHANGED AFTER startOfWeek())OR(not status CHANGED DURING ("-5d", now()) AND not status CHANGED BEFORE startOfWeek()))
but i recommend you to try Time in Status for Jira , where in 2 clicks you can exclude weekends by calendars and filter data by issue or time ranges and get your report. All the reports you can display as Pie, Bar or Area Charts.Add-on has a 30-day free trial version and free up to 10 users.You can also book a live demo - we'll show you the application inside out and answer all your questions.Have a nice day 🥳
Hi @Ambrosino Salvatore , welcome to the Community!
Below JQL excludes weekends. Hope it helps.
(not status CHANGED DURING ("-3d", now()) AND not status CHANGED AFTER startOfWeek()) OR (not status CHANGED DURING ("-5d", now()) AND not status CHANGED BEFORE startOfWeek())
Hi @Valeriia_Havrylenko_SaaSJet , thanks for your feedback, but doesn't work. I need that jql to integrate it in an automation that write a comment if a issue in status "Waiting Done" doesn't change in other status in last 3 days excluding weekend (Saturday and Sunday).
hi @Mehmet A _Bloompeak_ thanks for your feedback, but doesn't work. I need that jql to integrate it in an automation that write a comment if a issue in status "Waiting Done" doesn't change in other status in last 3 days excluding weekend (Saturday and Sunday). With your jql appear issues from other projects also.
Hi @Ambrosino Salvatore ,
If you want to restrict it to a single project then you can prepend your project JQL into it as below.
project=YOUR_PROJECT_KEY AND ((not status CHANGED DURING ("-3d", now()) AND not status CHANGED AFTER startOfWeek()) OR (not status CHANGED DURING ("-5d", now()) AND not status CHANGED BEFORE startOfWeek()))
Ok thanks. I will try it!
@Ambrosino Salvatore This JQL should work
Project=X AND ((NOT Status Changed AFTER -3d AND not status CHANGED AFTER startOfWeek())
Hope it helps
It looks like you're new here. Sign in or register to get started.
