Why
- I want to be able to go to Special:NewPagesFeed -> New Page Patrol -> Oldest and figure out how far behind we are on NPP reviewing (how big the "backlog" is) by looking at the dates
- The dates are currently page creation date, not enqueue date
- I want to be able to look at a page in the queue and see what date it was enqueued
- Old pages, for example pages created in 2004, are frequently flipped from redirects to articles, showing up in the NPP queue with a date from 2004, instead of a date from when they were enqueued in 2025
- I also want these "created in 2004" pages to be reviewed in the order they were enqueued, and not automatically go to the back of the queue
What
Work that will be invisible to the end user:
- Add a new SQL field to track enqueued date
- Update tables.json
- Make a ticket to have the field created on enwiki, testwiki, and anywhere else PageTriage is installed in production
- Update https://www.mediawiki.org/wiki/Extension:PageTriage/pagetriage_page_table to document the new field
- Write a maintenance script to backfill this field for all existing articles, copying the value of ptrp_reviewed_updated (which is a good approximate value)
- Make sure the following actions set this field correctly:
- creating a page
- moving a page (including from non $wgPageTriageNamespaces to $wgPageTriageNamespaces)
- undeleting a a page
- flipping from article to redirect?
- flipping from redirect to article?
- reviewing an article?
- unreviewing an article?
- Add a new, separate setting to New Page Patrol -> pagetriagelist action API query to use enqueued date
Work that will be visible to the end user:
TBD - need to determine exactly what will change.
- do we add enqueued date alongside creation date as a filter, similar to what AFC does, or just change it over? Fram was saying that for reviewed articles, it's weird to review by enqueued date, so we should keep that in mind
- what should the new default be?
- should we also change the date displayed in each article row? (probably. have it always match the filter setting I assume. maybe check what AFC does)
- I assume leave the algorithm in the Page Curation toolbar for the "next page in queue" button alone. this was one of the regressions using the previous approach
- the infinite scroll feature of Special:NewPagesFeed broke last time when using enqueued date. be sure to test this
- change "oldest" in Special:NewPagesFeed footer to reflect oldest enqueued date
Notes
- I am going to merge a bunch of tickets into this one. I could have chosen one of those and edited it with all this info, but I decided a fresh ticket would be better.
- the "real" back of the queue is easier to find with this Quarry query ( https://quarry.wmcloud.org/query/99823 ) than by looking at the Special:NewPagesFeed. looks like it starts around Feb 1, 2025, so 10 months.
