Default sorting of sessions

[marcinfigiel]

Preflight checklist

• I could not find a solution in the existing issues, docs, nor discussions.
• I agree to follow this project's Code of Conduct.
• I have read and am following this repository's Contribution Guidelines.
• This issue affects my Ory Network project.
• I have joined the Ory Community Slack.
• I am signed up to the Ory Security Patch Newsletter.

Describe your problem

Currently, the sessions returned by the /admin/sessions and /admin/identities/{id}/sessions endpoints are not sorted in a useful manner. This poses challenges or even renders these endpoints unusable, depending on the use case. For example, it becomes difficult to find a user's last login time.
Having a default sorting that returns the newest session first would greatly enhance the usability of these endpoints.

Describe your ideal solution

Sort the sessions so the newest ones are returned first.

Workarounds or alternatives

I can fetch all the sessions and sort them on my end to find what I'm looking for, but it's not a feasible solution.

Version

SaaS

Additional Context

No response

[kelkarajay]

@marcinfigiel there was work in progress to fix that here - #2939. There was (iirc) one failing test that remained