JQL for issue in status for last 3 or more business days

[Muhammad Moazzam Hassan]

Hi,

I need the JQL query for getting those issues that are currently in certain status for the last 3 or more business days.

[Tessa Tuteleers · Accepted solution]

Hi @Muhammad Moazzam Hassan , 

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

[Muhammad Moazzam Hassan]

Thanks, let me test it and will get back to you

[Jared Kells]

That JQL is awesome :)

[Muhammad Moazzam Hassan]

Thanks for the great answer.

[Rick Robinson-Donnellan]

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.

[Jared Kells]

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