opsgenie How to sort the results of a saved search?

[swaitkevich]

 I see no "order by" or "sort" clause in the OpsGenie query language.  My results to this query are coming out most recent first by create time and I'd like the oldest first.

(responders: "xxxx" or responders: "yyyy") and createdAt >=1733770800000 and createdAt <=1734375600000

[Egor · Accepted solution]

Hey There,
Thanks for reaching out to Atlassian Community!

You're correct that the Opsgenie query language does not currently support an "order by" or "sort" clause. The results are always sorted by the creation time, with the most recent alerts shown first.

Unfortunately, there isn’t a way to natively sort the results to display the oldest alerts first within Opsgenie. A possible workaround is to export the alert data (e.g., using the Opsgenie API) and sort it in an external tool like Excel or a database query.

Please let me know if it helps and if you have any further questions.


Best Regards,
Egor

[swaitkevich]

Thanks for the info Egor!