Hi,
I need the JQL query for getting those issues that are currently in certain status for the last 3 or more business days.
If you didn't use business days, your query would look like this:
status = "In Progress" AND status changed TO "In Progress" BEFORE -3d
JQL does not have a "business day" concept, but you have weeks and days, if you want to, you could make calculations for your 3 business days (using the weekends as non-business days, not another schedule you define yourself).
I found another question describing this here.
It would look like this:
status = "In Progress" AND ((status changed TO "In Progress" BEFORE -3d AND status changed TO "In Progress" AFTER startofWeek()) OR status changed TO "In Progress" BEFORE -5d)
-> Meaning if 3 days ago was before the start of the week, count 5 days back instead of three (accounting for 2 weekend days)
Hope it helps!
- Tessa
Thanks, let me test it and will get back to you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This answered my issue as well, thanks Tessa.
Modified mine slightly to produce a list of tickets not updated in longer than 3 business days.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm not sure if it's possible to run JQL queries related that respect business days with plain JQL. There are add-ons that can do more sophisticated queries.
If you drop the business days requirement you could use something like:
status = 'in progress' AND status changed to 'in progress' before -3d
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.