Re: [Semediawiki-user] Sorting by creation date

[<Mic...@ex...>]

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.                                                       
      Mic...@ex...                                         
      office: 585-301-8345                                                 
                                                                           





                                                                           
             "Sergey                                                       
             Chernyshev"                                                   
             <semediawiki-user                                          To 
             @antispam.sergeyc         sem...@li...urceforge. 
             hernyshev.com>            net                                 
             Sent by:                                                   cc 
             semediawiki-user-                                             
             bo...@li...u                                     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 <ski...@ea...> 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
Sem...@li...
https://lists.sourceforge.net/lists/listinfo/semediawiki-user