Page MenuHomePhabricator
Create Task
Maniphest T347102

Alias column names in Special:Investigate to not include the "cuc_" prefix
Open, Needs TriagePublic3 Estimated Story Points
Actions

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

Details

SubjectRepoBranchLines +/-
Alias SELECT queries for Investigate 'IPs & User agents' tabmediawiki/extensions/CheckUsermaster+71 -71
Alias SELECT queries for Investigate 'Timeline' tabmediawiki/extensions/CheckUsermaster+264 -59
Customize query in gerrit

Related Objects
Search...

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
· · ·
OpenNoneT329200 Enable read new support in Special:Investigate's 'Timeline' tab
OpenDreamy_JazzT329201 Enable read new support in Special:Investigate's 'IPs & User agents' tab
OpenDreamy_JazzT347102 Alias column names in Special:Investigate to not include the "cuc_" prefix
ResolvedDreamy_JazzT362152 Improve test coverage on Special:Investigate code
Restricted Task
· · ·

Event Timeline

Dreamy_Jazz created this task.Sep 21 2023, 6:11 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 21 2023, 6:11 PM
Dreamy_Jazz mentioned this in T329201: Enable read new support in Special:Investigate's 'IPs & User agents' tab.Sep 21 2023, 6:12 PM
Dreamy_Jazz mentioned this in T329200: Enable read new support in Special:Investigate's 'Timeline' tab.
Dreamy_Jazz moved this task from Ready 🎬 (ONLY IF YOU HAVE NO MORE CODE TO REVIEW) to In Progress 💪 on the Anti-Harassment (AHaT Sprint 32 - Baseball Cap) board.
Dreamy_Jazz added parent tasks: T329200: Enable read new support in Special:Investigate's 'Timeline' tab, T329201: Enable read new support in Special:Investigate's 'IPs & User agents' tab.
gerritbot added a comment.Sep 21 2023, 6:25 PM

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

gerritbot added a project: Patch-For-Review.Sep 21 2023, 6:25 PM
Dreamy_Jazz moved this task from General / Unsorted to CheckUser on the CheckUser board.Sep 21 2023, 8:31 PM
Dreamy_Jazz moved this task from CheckUser to Investigate on the CheckUser board.
Dreamy_Jazz edited projects, added Anti-Harassment; removed Patch-For-Review, Anti-Harassment (AHaT Sprint 32 - Baseball Cap).Oct 2 2023, 2:36 PM

Moving out of the current sprint.

Dreamy_Jazz moved this task from Untriaged to CheckUser on the Anti-Harassment board.Oct 2 2023, 2:37 PM
gerritbot added a comment.Oct 8 2023, 9:43 PM

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

Dreamy_Jazz edited projects, added Trust and Safety Product Sprint (Sprint Tabla (1st - 14th April)), Trust and Safety Product Team; removed Anti-Harassment.Thu, Apr 11, 2:46 PM
Dreamy_Jazz moved this task from Priority Backlog to In Progress on the Trust and Safety Product Sprint (Sprint Tabla (1st - 14th April)) board.
gerritbot added a comment.Thu, Apr 11, 2:47 PM

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

gerritbot added a project: Patch-For-Review.Thu, Apr 11, 2:47 PM
Dreamy_Jazz moved this task from In Progress to Ready on the Trust and Safety Product Sprint (Sprint Tabla (1st - 14th April)) board.Mon, Apr 15, 12:08 PM

Blocked on T362152

Dreamy_Jazz added a subtask: T362152: Improve test coverage on Special:Investigate code.Mon, Apr 15, 12:14 PM
Dreamy_Jazz set the point value for this task to 3.Fri, Apr 19, 11:38 AM
Dreamy_Jazz closed subtask T362152: Improve test coverage on Special:Investigate code as Resolved.Fri, Apr 19, 3:45 PM
Dreamy_Jazz edited projects, added Trust and Safety Product Sprint (Sprint Kazoo (Jan 29 - Feb 9 2024)); removed Trust and Safety Product Sprint (Sprint Tabla (1st - 14th April)).Tue, Apr 23, 10:55 AM
Dreamy_Jazz edited projects, added Trust and Safety Product Sprint (Sprint Pennywhistle (23rd April - 3rd May)); removed Trust and Safety Product Sprint (Sprint Kazoo (Jan 29 - Feb 9 2024)).Tue, Apr 23, 10:58 AM
Dreamy_Jazz moved this task from Priority Backlog to In Progess on the Trust and Safety Product Sprint (Sprint Pennywhistle (23rd April - 3rd May)) board.Tue, Apr 23, 1:14 PM
gerritbot added a comment.Tue, Apr 23, 5:48 PM

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

gerritbot added a comment.Wed, Apr 24, 4:30 PM

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

Dreamy_Jazz mentioned this in T363376: Move code that groups and sorts the rows from the CheckUser result tables to the CheckUserLookupUtils service to reduce duplication.Wed, Apr 24, 6:54 PM
Dreamy_Jazz removed a subtask: T363376: Move code that groups and sorts the rows from the CheckUser result tables to the CheckUserLookupUtils service to reduce duplication.Wed, Apr 24, 8:04 PM
Dreamy_Jazz added a subtask: Restricted Task.Thu, Apr 25, 9:50 AM
Dreamy_Jazz moved this task from In Progess to Ready on the Trust and Safety Product Sprint (Sprint Pennywhistle (23rd April - 3rd May)) board.Fri, Apr 26, 10:02 AM
Dreamy_Jazz closed subtask Restricted Task as Resolved.Tue, Apr 30, 1:48 PM
Dreamy_Jazz reopened subtask Restricted Task as Open.Tue, Apr 30, 1:51 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL