Replace raw SQL with a builder for the sub-query on ZObjectAlphabeticPager::getQueryInfo()
Open, MediumPublic
Actions

Edit Task
Edit Related Tasks...
Create Subtask
Edit Parent Tasks
Edit Subtasks
Merge Duplicates In
Close As Duplicate
Edit Related Objects...
Edit Commits
Edit Mocks
Mute Notifications
Protect as security issue

Assigned To

Authored By

	Jdforrester-WMF
	Nov 11 2024, 2:37 PM

Description

We're using raw SQL strings rather than SQLPlatform->selectSQLText(), because we couldn't see how to use ROW_NUMBER() OVER PARTITION BY. Is this feature unavailable?

Event Timeline

Jdforrester-WMF created this task.Nov 11 2024, 2:37 PM

gengh claimed this task.Nov 12 2024, 9:02 AM

Jdforrester-WMF triaged this task as Medium priority.Nov 13 2024, 5:32 PM

Jdforrester-WMF moved this task from To Triage to Engineering Backlog on the Abstract Wikipedia team board.

You should be able to use that as a raw sql in condition or select by wrapping it around RawSQLExpression.

Replace raw SQL with a builder for the sub-query on ZObjectAlphabeticPager::getQueryInfo()Open, MediumPublicActions

Description

Event Timeline

Replace raw SQL with a builder for the sub-query on ZObjectAlphabeticPager::getQueryInfo()
Open, MediumPublic
Actions