Page MenuHomePhabricator

Suggested investigations: Sorting by status doesn't always work
Closed, ResolvedPublicBUG REPORT

Description

Summary

Sorting by case status does not always appear to work consistently. When sorting by status, the statuses should be sorted such that they are grouped together. Instead, it seems that the sorting doesn't do this correctly.

Background

  • The CheckUser-SuggestedInvestigations special page has a "Status" column which can be sorted such that a user can see all cases with a given status grouped
    • This column should group cases by their status and then sort those groups by the created timestamp
    • However, this filtering is not working as expected in some cases

Acceptance criteria

  • Sorting by status works as intended

Event Timeline

Dreamy_Jazz changed the subtype of this task from "Task" to "Bug Report".Sep 25 2025, 3:18 PM
mszwarc changed the task status from Open to In Progress.Sep 29 2025, 8:27 AM
mszwarc claimed this task.

Change #1192057 had a related patch set uploaded (by Mszwarc; author: Mszwarc):

[mediawiki/extensions/CheckUser@master] SI: Fix sorting by status

https://gerrit.wikimedia.org/r/1192057

Change #1192057 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] SI: Fix sorting by status

https://gerrit.wikimedia.org/r/1192057

Change #1192098 had a related patch set uploaded (by Kosta Harlan; author: Mszwarc):

[mediawiki/extensions/CheckUser@wmf/1.45.0-wmf.20] SI: Fix sorting by status

https://gerrit.wikimedia.org/r/1192098

Change #1192098 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@wmf/1.45.0-wmf.20] SI: Fix sorting by status

https://gerrit.wikimedia.org/r/1192098

Mentioned in SAL (#wikimedia-operations) [2025-09-29T11:23:10Z] <kharlan@deploy2002> Started scap sync-world: Backport for [[gerrit:1192098|SI: Fix sorting by status (T405605)]], [[gerrit:1192097|UIC: Disable external permission check for Active wikis section (T405889)]]

Mentioned in SAL (#wikimedia-operations) [2025-09-29T11:49:52Z] <kharlan@deploy2002> kharlan: Backport for [[gerrit:1192098|SI: Fix sorting by status (T405605)]], [[gerrit:1192097|UIC: Disable external permission check for Active wikis section (T405889)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Sorting by status has been fixed and backported to wikis. However, if sorting by status, the cases are also sorted by the timestamp (as a secondary field). It means that toggling the order in which the statuses are displayed affects the timestamps as well. This is necessary to use the database index. The user experience around this will be better once we implement filtering by status: T405673: Should support filtering, not just sorting

Mentioned in SAL (#wikimedia-operations) [2025-09-29T12:07:21Z] <kharlan@deploy2002> Finished scap sync-world: Backport for [[gerrit:1192098|SI: Fix sorting by status (T405605)]], [[gerrit:1192097|UIC: Disable external permission check for Active wikis section (T405889)]] (duration: 44m 11s)