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

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 UTC