Ordering by attribute change date?

[Eimantas Vaičiūnas]

My mind was blown when I discovered that I can use the CHANGED operator in my JQL queries. And that definitely made the work great.

However I could not find anywhere if there's a possibility to order the issues by the date when the value was changed (e.g. `status CHANGED TO 'Done' AFTER 2023-06-31 ORDER BY status CHANGED`). To my knowledge I'd need a separate field now for the issues that would be set when the status changes and then I could sort by that field. But this just adds up to setup and potential for human error.

Is there a way to sort the issues in JQL by the date when an attribute value was changed?

[Aron Gombas _Midori_ · Accepted solution]

Linguistically, CHANGED is an operator, not a field and ordering can only be done by a field. I don't it will work.

And the best workaround is still to use the additional custom field updated every time when the status change by an automation rule or a post-function or something.