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

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