Summary

We want to order the accounts shown in the case view by their account age.

Background

• We have received feedback that it needs to be easier to find the account(s) which triggered a case
  • We currently do not have support in the database schema to store what accounts triggered a case
    • Adding this schema change may take a while to achieve, so we need a short-term solution that is acceptable to potentially be longer-term based on feedback
• Accounts which trigger the case are often newly created accounts, though this is not always the case
  • Ordering by account creation timestamp could solve this, but we do not have a way to do this easily (due to our database tables being not on the same cluster as tables with user registration dates)
    • However, ordering by the user ID descending is a good approximation for ordering by account creation date descending (as a user IDs are assigned via an autoincrement that starts from 0)

Acceptance criteria

• Accounts shown in cases on Special:SuggestedInvestigations are ordered by their user ID descending