Order identities and Sessions by "created at" in console

[mblarsen]

Preflight checklist

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

Ory Network Project

No response

Describe your problem

The list of identities shows identities by some order. It would be nice to be able to order them by created at (desc) so that you can see recently created identities in the console. This is especially useful for QA and debugging when creating a custom UI.

Describe your ideal solution

Clicking created at in the table would sort by created at.

Workarounds or alternatives

Only alternative right now is to download all identities using cli, import to own db and sort by date.

Version

?

Additional Context

No response

[kmherrmann]

@mszekiel PTAL - the same is true for the activities > sessions view, it should all be reverse chronological. Is this easy to do or would it require more refactoring on the API side?

[mszekiel]

It's easy to achieve, already on my list and work in progress.

[aeneasr]

Our API doesn't support ordering yet, so it will be a bit more involved to get this working. Also will need correct indices on the columns or we'll run into timeouts!

[jonas-jonas]

The identities part still needs to be done, I think. But that's a bit more involved...