Page MenuHomePhabricator

Allow for sorting Special:UnreviewedPages by time since creation
Open, MediumPublicFeature

Description

Allow for sorting Special:UnreviewedPages by time since creation.

Requested on pl.wikipedia: https://pl.wikipedia.org/wiki/Wikipedia:Kawiarenka/Kwestie_techniczne#Nieprzejrzane_strony


Version: unspecified
Severity: enhancement
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=15293

Details

Reference
bz43857

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:36 AM
bzimport set Reference to bz43857.
bzimport added a subscriber: Unknown Object (MLST).

This request makes a lot of sense. I would even say that sorting by date is more relevant that sorting alphabetically. Is it EASY enough to deserve such keyword?

No idea.

It has, however, just been asked for again on the same venue at pl.wp.

QEDK reopened this task as Open.
QEDK claimed this task.

Oops.

QEDK removed QEDK as the assignee of this task.Jan 18 2016, 3:42 PM
QEDK added a subscriber: QEDK.

It seems rather hard. It queries the page table with left join on flaggedpages to filter out pages which have a reviewed version. page has a lexicographic index but no time-based index; doesn't even contain that information in an unindexed way. You'd have to rely on the page creation log (which is unreliable in many ways) or walk the revision table's (rev_page, rev_id) index. And it uses the querycache table (in a custom hacky way as it's not actually a QueryPage subclass) so you would need to cache the two sorting modes separately. And the code is of course 100% undocumented.

...although maybe for querycache it's fine to just do a filesort on the page table (filtered by namespace)? It's a few million rows at most.

Aklapper changed the subtype of this task from "Task" to "Feature Request".Feb 4 2022, 12:24 PM
Aklapper removed a subscriber: wikibugs-l-list.