encode_submission/failed-submissions.sparql

   1 ##
   2 ## Find submissions that are currently "failed"
   3 ##
   4
   5 PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
   6 PREFIX submitOnt:<http://jumpgate.caltech.edu/wiki/UCSCSubmissionOntology#>
   7 PREFIX libOntNS:<http://jumpgate.caltech.edu/wiki/LibraryOntology#">
   8
   9 #libraryNS = RDF.NS("http://jumpgate.caltech.edu/library/")
  10 #submissionNS = RDF.NS("http://encodesubmit.ucsc.edu/pipeline/show/")
  11 #ddfNS = RDF.NS("http://encodesubmit.ucsc.edu/pipeline/download_ddf#")
  12
  13 SELECT
  14  ?subid ?subname ?liburn ?status
  15 WHERE {
  16   ?subid submitOnt:name ?subname .
  17   ?subid submitOnt:library_urn ?liburn .
  18   ?subid submitOnt:has_status ?statusNode .
  19   ?statusNode submitOnt:status ?status .
  20   ?statusNode submitOnt:last_modify_date ?last_modify .
  21   FILTER (regex(?status, "failed", "i"))
  22 }