Last modified: 2014-07-23 11:19:19 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T70428, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 68428 - API: Allow page_id sort order for list=allpages
API: Allow page_id sort order for list=allpages
Status: NEW
Product: MediaWiki
Classification: Unclassified
API (Other open bugs)
1.24rc
All All
: Low enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-07-23 08:40 UTC by db [inactive,noenotif]
Modified: 2014-07-23 11:19 UTC (History)
5 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description db [inactive,noenotif] 2014-07-23 08:40:23 UTC
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.
Comment 1 Brad Jorsch 2014-07-23 11:19:19 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links