I want to find out the tickets which are not updated for last 3 days[ Excluding Weekends ].
Is it possible using Jira JQL filters?
Thanks in Advance.
Hi folks
You might like to look at my answer on https://community.atlassian.com/t5/Jira-questions/Need-filter-for-tickets-not-updated-for-last-3-days-excluding/qaq-p/1437566 which is looking at the rolling last 3 work days. For an explanation of the logic I used there.
Building on the JQL provided by @Christos Moysiadis
(updated < -3d AND updated > startofWeek(-1d)) OR (updated < -5d and updated < startofweek(-1d))
Hope this is still useful to someone out there.
Phill
Hi @Madhu Mullangi ,
yes i am sure its possible.try to run this jql:
Hope this info is helpful for you. maybe some customisations in the -/+ days will be needed ,because i dont know how your working calendar is.
Extra info:
Best regards
CM
@Christos Moysiadis Thanks for your Response.
I am totally confused with your Answer.
I think you are not clear with my question.I want tickets which are not updated for lats 3 days[Thursday,Friday,Monday] excluding weekends.
Today is Tuesday and my result should be tickets not updated from last Thursday Onwards i.e. [Monday, Friday, Thursday].
@Madhu Mullangi many many sorrys. i missread this not. I ll try to find out the solution and repost it here.
@Christos Moysiadis did you find a solution?
I have the same issue as the others, any solution? Thank you guys!
Hi @Phill Fox my Scenario changed and Now I want to find the tickets which are not updated for the last 2 days and Exclude the weekends.
Could you please help me in this regard.
Hi @Madhu Reddy
I covered that use case in this answer https://community.atlassian.com/t5/Jira-questions/Need-filter-for-tickets-not-updated-for-last-3-days-excluding/qaq-p/1437566 although this was for 3 days not 2. Please review that for the description of the logic but the based additional criteria for time is (updated <-2d AND > startofweek()) OR (updated < -4d AND updated > startofWeek(-2d) AND updated < startofweek())
Hey @Phill Fox !
Sorry to make you the defacto "ignore weekends" expert, but you seem the most knowledgeable!
I am trying, using the Jira Automation feature, to flag tickets (flag = Impediment) that get stuck in "In Progress" or "Peer Review" for 3+ days.
I tried the following query:
sprint in openSprints() AND status in ("In Progress", "Peer Review") AND ((statusCategoryChangedDate < -3d AND statusCategoryChangedDate > startofWeek(-1d)) OR (statusCategoryChangedDate < -5d and statusCategoryChangedDate < startofweek(-1d))) AND Flagged is EMPTY ORDER BY Rank ASC
Which makes the following checks:
The 3 days + ignore weekends rule is not being respected. A ticket that transitioned to "In Progress" the previous day was flagged by the automation the following morning.
Any idea where I might be going awry?
Hi @Owen Scott
The first thing I would do to troubleshoot this is to look closely at the ticket that was identified and work out the reason the logic thought it should be flagged.
Looking at your logic you need to check which of these two conditions matched as true. I cannot see a reason why an issue transitioned the previous day would match either of these conditions.
Is it possible that the statusCategoryChangedDate field did not get updated on the issue? And so it was picking up a previous entry?
I am not clear why you are looking at startOfWeek(-1d) in this logic I would have used startOfWeek()
Another thing to check is where Jira considers the start of week as being! This is a very useful configuration item that allows organisations to adjust to whether they consider the start of the week as a Monday or Sunday. You can quickly check if this is the case by looking at any date picker and checking to see if the calendar is displayed as Sunday/Monday for the start of each week.
On Cloud you change the setting on <yourdomain>.atlassian.net/secure/admin/LookAndFeel
For on premise this needs to be set in the JVM as it defaults to your server locale.
To override, you need to set JVM parameters on Jira service to language and country that is set for Monday e.g. Germany would have this
-Duser.language=de
-Duser.country=DE
However if we look at the logic you have around StartOfWeek in the two scenarios of Sunday and Monday week starts we might be able to identify a change that would work for you.
With the start of the week on a Monday and executed on Monday: StartOfWeek(-1) will look at the previous week
Whereas the start of the week on a Sunday and executed on Monday: StartOfWeek(-1) will look at the current week
Hope this helps you and others troubleshoot their scenarios.
@Christos Moysiadis
@Phill Fox
My problem is very similar, hence I do not wish to open a new topic of discussion:
Here is my description.
We have a service level agreement (SLA) with our customer facing team. It says once the bug is created, within 3 business days, the status should move to at least "IN-DEV" (closed is not possible as the Queue of tickets is long).
So we have created a custom field called as "SLA breach". This field should have "YES" value if the duration between "NEW" and "IN-DEV" is longer than 3 business days (but exclude weekends).
Example:
I know the Automation and I have created the cron jobs to run every night.
My problem is -3d is not excluding the weekend. (So A bug created on Friday, is flagged as SLA breach on Monday itself as Sat and Sun are counted by system)
Can you please suggest me a JQL filter to have the SLA breach for above conditions that will exclude weekends from the counting of "3 days"?
In other words I just want to count business days.
Hi team,
I need to check only the tickets assigned and not taken any action for last 3 days of working days
Hi @Rajesh Ramankutty ,
Hope below JQL works.
assignee IS NOT EMPTY AND NOT ( updated >-3d OR (updated > -5d AND updated > startofWeek(-3d) AND updated < startofweek()))
It looks like you're new here. Sign in or register to get started.
