I'm not sure all are aware but there are a number of native MediaWiki attributes that one can use when creating dynamic lists (queries) with the Dynamic Page List extension (DPL). The SMW developers might want to take a peak at that code.
It would be wonderful if all the query choices available in DPL were available in an <ask> . Our site uses DPL extensively, Now we find ourselves using DPL sometimes and SMW other times. I'd like to be able to just standardize on one dynamic query tool. But so far DPL can still do a lot that SMW can not when it comes to native MediaWiki page attributes, like creation date or last edit date, etc. It also allows logical "and" and "or" in queries. For example show me all pages from: (category a AND ( category b OR category c)). We use DPL to build blog like news feed on the front page (using a category called "News" of course). see: http://www.mediawiki.org/wiki/Extension:DynamicPageList and the home page: http://semeb.com/dpldemo/index.php/Main_Page The DPL query options might represent a reasonable benchmark for SMW. If DPL can do it, so SMW should be able to also.... Mike Mike Axelrod Solution Architect Enterprise Architecture & Integration Team Excellus, Inc. [EMAIL PROTECTED] office: 585-301-8345 "Sergey Chernyshev" <semediawiki-user To @antispam.sergeyc [EMAIL PROTECTED] hernyshev.com> net Sent by: cc semediawiki-user- [EMAIL PROTECTED] Subject rceforge.net Re: [Semediawiki-user] Sorting by creation date 05/17/2007 02:24 PM Please respond to semediawiki-user@ lists.sourceforge .net Hm... it's quite bad. So what are my options here then? Manually set an attribute that will be set for each page? I can probably run a bot for that, but it's quite unusual way of doing this ;) On 5/17/07, S Page <[EMAIL PROTECTED]> wrote: Sergey Chernyshev wrote: > I'm trying to replace DLP functionality on my site [what's "DLP functionality"?] > with SMW queries but > I'm having troubles getting N latest pages. > > Is there any way for me to run a query and order by page creation date? > It seems to be simple functionality buy it looks like I'm stuck. I don't believe so. There is some semantic info in MediaWiki already, such as lastmod, viewcount, creator, and contributors. MediaWiki can even export some of this as RDF with action=creativecommons (e.g. http://discoursedb.org/w/index.php?title=Newsweek&action=creativecommons , note many wikis disable this feature). But SMW can't query or display it because it's not maintained in the smw_* database tables. You could imagine SMW having the smarts to query for such special bits of information, maybe using reserved words or a prefix. But note this MediaWiki information is not information about the page's subject, but meta-information about the page. The creator, datecreated and lastmod of the wiki page about "King Lear" are not going to be "William Shakespeare", "1603", and "1606". So if you were to modify MediaWiki to update the smw_* database tables with meta-information about each page edit, it doesn't strictly make sense. Although MediaWiki provides its page meta-information in various places, it doesn't make it easy to get. I'm not sure you can even reliably get the initial page creation date from MediaWiki. I think the closest you can get at the database level is the revision.rev_timestamp of the earliest rev_id in the revision table where revision.rev_page = page.page_id. Special:Recentchanges relies on a separate recentchanges table that mediawiki maintains, and the lastmod displayed at the bottom of a page is the revision.rev_timestamp; there's also a page.page_touched which I think is updated on any change. -- =S Page ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Semediawiki-user mailing list Semediawiki-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-user ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Semediawiki-user mailing list Semediawiki-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-user
