JQL to find issues with a status for more than 2 weeks

[Colum McAndrew]

I'm trying to run a JQL query to find issues with a particular status that have held that status for more than two weeks. The trouble is I can't seem to find anything that holds this information. There is UpdatedDate, but that could include issues that have been updated in some other way. Is there a way of achieving what I need.

[Jack Brickey · Accepted solution]

This will generally work but it does not cover the case where it changed statuses and then went back to the previous status during the 14d window.

status = "particular status" and status was "particular status" before startOfDay(-14)

[Colum McAndrew]

Thank you @Jack Brickey I'll give that a go. This is a bit of an issue as the JQL is required for an automation rule and our workflow is such that the status an issue was could be multiple statuses. I guess I'll just have to set up multiple automation rules, one for each status.