Last modified: 2007-09-04 14:31:33 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 T12890, the corresponding Phabricator task for complete and up-to-date bug report information.
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