API: Allow page_id sort order for list=allpages
Open, LowPublicFeature
Actions

Assigned To

None

Authored By

	duplicatebug
	Jul 23 2014, 8:40 AM

Description

list=allpages gives pages in order of titles to the given namespace. It should also be possible to get the pages in page_id order.

This allows getting newer pages easier as with Special:NewPages/list=recentchanges and over the 30 days.

Maybe add a apsort=title|pageid param
Having the apnamspace param still working would be nice.

Version: 1.24rc
Severity: enhancement

Details

Reference: bz68428

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 22 2014, 3:42 AM

• bzimport added a project: MediaWiki-Action-API.

• bzimport set Reference to bz68428.

• bzimport added a subscriber: Unknown Object (MLST).

duplicatebug created this task.Jul 23 2014, 8:40 AM

While this looks easy, anyone attempting this should be sure they are familiar with MySQL query optimization. The query is currently along the lines of "SELECT ... FROM page WHERE page_namespace = '0' ORDER BY page_title", using the name_title index on the page table. Be sure your new query is still indexed and is not filesorting.

duplicatebug unsubscribed.Dec 13 2014, 4:38 PM

Anomie moved this task from Unsorted to Needs details or plan on the MediaWiki-Action-API board.Feb 19 2015, 6:33 PM

Aklapper removed subscribers: Anomie, • wikibugs-l-list.Oct 16 2020, 5:03 PM

Aklapper changed the subtype of this task from "Task" to "Feature Request".Feb 4 2022, 11:13 AM

Bugreporter2 awarded a token.Jan 8 2023, 3:45 AM

Bugreporter2 subscribed.

API: Allow page_id sort order for list=allpagesOpen, LowPublicFeatureActions

Description

Details

Event Timeline

API: Allow page_id sort order for list=allpages
Open, LowPublicFeature
Actions