Page MenuHomePhabricator

Alias column names in Special:Investigate to not include the "cuc_" prefix
Closed, ResolvedPublic3 Estimated Story Points

Description

Special:Investigate needs to reference column names that have no "cuc_" prefix as when reading from the three tables the prefix for a set of rows will be different.

Acceptance criteria
  • Alias the current query info fields in TimelineService, TimelinePager and TimelineRowFormatter use aliases for the cu_changes fields that are selected
  • Alias the current query info fields in CompareService and ComparePager use aliases for the cu_changes fields that are selected

Event Timeline

Change 959836 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] [WIP] SpecialInvestigate: Alias SELECT fields for cu_changes queries

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

Change 959836 abandoned by Dreamy Jazz:

[mediawiki/extensions/CheckUser@master] [WIP] SpecialInvestigate: Alias SELECT fields for cu_changes queries

Reason:

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

Change #959836 restored by Dreamy Jazz:

[mediawiki/extensions/CheckUser@master] [WIP] SpecialInvestigate: Alias SELECT fields for cu_changes queries

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

Dreamy_Jazz set the point value for this task to 3.Apr 19 2024, 11:38 AM

Change #1023476 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] [WIP] Alias SELECT queries for Investigate 'IPs & User agents' tab

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

Change #1023890 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] [WIP] Add common grouping and sorting methods to CheckUserLookupUtils

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

Change #1023476 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Alias SELECT queries for Investigate 'IPs & User agents' tab

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

Change #959836 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Alias SELECT queries for Investigate 'Timeline' tab

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

Proposing that no QA is performed because this should have performed no changes and this will be QA'd through parent tickets.