W3C home > Mailing lists > Public > public-rdf-dawg@w3.org > July to September 2005

Re: last call status report (and SPARQL queries thereupon)

From: Dan Connolly <connolly@w3.org>
Date: Wed, 03 Aug 2005 16:16:43 -0500
To: Eric Prud'hommeaux <eric@w3.org>
Cc: RDF Data Access Working Group <public-rdf-dawg@w3.org>
Message-Id: <1123103803.18971.391.camel@localhost>

On Mon, 2005-08-01 at 12:26 -0500, Dan Connolly wrote:
> OK, I've got a LC status report working
>   http://www.w3.org/2001/sw/DataAccess/lc-status-report.html

I fixed the intermediate data to be in .rdf format rather
than in .n3 and published it at...

http://www.w3.org/2001/sw/DataAccess/lc-threads.rdf

So we can eat our own DAWGfood...

get the subjects of all the threads:

PREFIX review: <http://www.w3.org/2001/sw/DataAccess/lc-comment-rules#>
PREFIX email: <http://www.w3.org/2000/10/swap/pim/email#>
SELECT ?subject
FROM <http://www.w3.org/2001/sw/DataAccess/lc-threads.rdf>
 WHERE
{ ?M email:subject ?subject; review:threadRoot ?M.  }


Try that with any of the http://esw.w3.org/topic/DawgShows
e.g. http://sparql.org/query.html

OR just open threads:

...
 WHERE
{ ?M email:subject ?subject; review:threadRoot ?M.
OPTIONAL { ?M review:threadTail ?T}
OPTIONAL { ?M review:threadReply ?R}
FILTER ((! bound(?T)) && (! bound(?R)))  }

all the reviewers (and other folks that replied):

SELECT DISTINCT ?name ?mbox
FROM <http://www.w3.org/2001/sw/DataAccess/lc-threads.rdf>
 WHERE
{ ?M email:from ?who.
  ?who email:mbox ?mbox.
  OPTIONAL { ?who email:phrase ?name } }

just people that started threads:

SELECT DISTINCT ?name ?mbox
FROM <http://www.w3.org/2001/sw/DataAccess/lc-threads.rdf>
 WHERE
{ ?M email:from ?who; review:threadRoot ?M.
  ?who email:mbox ?mbox.
  OPTIONAL { ?who email:phrase ?name } }

hmm... it lists me... ah... because my "start your engines!"
message wen to the comments archive. And it lists EricP
because of some wierdness with the [OK?] flag that I haven't
diagnosed.

Next step is to connect-the-dots with the issues list...


-- 
Dan Connolly, W3C http://www.w3.org/People/Connolly/
D3C2 887B 0F92 6005 C541  0875 0F91 96DE 6E52 C29E
Received on Wednesday, 3 August 2005 21:16:47 GMT

This archive was generated by hypermail 2.3.1 : Tuesday, 26 March 2013 16:15:24 GMT