From: Diane Trout <diane@caltech.edu>
Date: Wed, 20 Jul 2011 00:38:27 +0000 (-0700)
Subject: Make searching library & cell line more robust to missing data
X-Git-Tag: 0.5.3~20
X-Git-Url: http://woldlab.caltech.edu/gitweb/?p=htsworkflow.git;a=commitdiff_plain;h=575ffb39badc5ebee722b3ff02be7b742de49b0d

Make searching library & cell line more robust to missing data
and add example to limit to a date range, to help with status reports.
---

diff --git a/extra/ucsc_encode_submission/find-lib-by-cell.sparql b/extra/ucsc_encode_submission/find-lib-by-cell.sparql
index ca1615e..3e149f4 100644
--- a/extra/ucsc_encode_submission/find-lib-by-cell.sparql
+++ b/extra/ucsc_encode_submission/find-lib-by-cell.sparql
@@ -1,14 +1,16 @@
 # Produce list of submissions associated with a cell/replicate
-
+PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
 PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
 PREFIX ucscSubmission:<http://jumpgate.caltech.edu/wiki/UcscSubmissionOntology#>
 PREFIX libraryOntology:<http://jumpgate.caltech.edu/wiki/LibraryOntology#>
 
-SELECT distinct ?liburn ?cell ?replicate ?subid
+SELECT distinct ?liburn ?cell ?replicate ?subid ?name ?submission_date
 WHERE {
-    ?subid ucscSubmission:library_urn ?liburn ;
+    ?subid libraryOntology:date ?submission_date ;
            ucscSubmission:name ?name .
-    ?liburn libraryOntology:cell_line ?cell ;
-            libraryOntology:replicate ?replicate .
+    OPTIONAL { ?subid ucscSubmission:library_urn ?liburn . 
+               ?liburn libraryOntology:cell_line ?cell ;
+                       libraryOntology:replicate ?replicate . }
+    #filter(?submission_date > "2011-04-01T00:00:00Z"^^xsd:dateTime)
 }
-ORDER BY ?cell ?replicate ?liburn
+ORDER BY ?submission_date ?cell ?replicate ?liburn