Last modified: 2007-09-04 14:31:33 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 10890 - Timestamp support for categorymembers query
Timestamp support for categorymembers query
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
API (Other open bugs)
unspecified
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
: patch, patch-need-review
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2007-08-12 08:21 UTC by Stephen Bain
Modified: 2007-09-04 14:31 UTC (History)
1 user (show)

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


Attachments
Patch to implement enhancement (2.93 KB, patch)
2007-08-12 08:21 UTC, Stephen Bain
Details

Description Stephen Bain 2007-08-12 08:21:41 UTC
Created attachment 3987 [details]
Patch to implement enhancement

This patch adds support to the categorymembers/cm query for the cl_timestamp field in the categorylinks table (which roughly approximates when a page was added to a category). It allows retrieval of timestamp data for category members, and introduces an option to choose how to sort the query (two options corresponding to table indices: by sortkey, which is the current method, or by timestamp).
Comment 1 Roan Kattouw 2007-09-03 20:40:27 UTC
Fixed in r23459, but without the sort option. I don't even know if we have an index to sort by timestamps, and frankly, I don't see why it would be of any use. All r23459 is add the cmprop=timestamp option.
Comment 2 Stephen Bain 2007-09-04 04:31:24 UTC
We do have an index to sort by timestamps, it's right there in tables.sql:

"KEY cl_timestamp (cl_to,cl_timestamp)"

http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sql?revision=25290&view=markup
Comment 3 Roan Kattouw 2007-09-04 14:31:33 UTC
Sort parameter added in r25474. The revision in comment #1 should of course be r25459, not r23459 (late night, made the 23/25 typo on another bug also).

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


Navigation
Links