From fc176863e60694aa36a3de8503815a6ddf8070ce Mon Sep 17 00:00:00 2001 From: Diane Trout Date: Fri, 30 Sep 2011 16:12:54 -0700 Subject: [PATCH] find submissions, even those without a set creation date --- extra/ucsc_encode_submission/find-lib-by-cell.sparql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) mode change 100644 => 100755 extra/ucsc_encode_submission/find-lib-by-cell.sparql diff --git a/extra/ucsc_encode_submission/find-lib-by-cell.sparql b/extra/ucsc_encode_submission/find-lib-by-cell.sparql old mode 100644 new mode 100755 index 3e149f4..c4585c5 --- a/extra/ucsc_encode_submission/find-lib-by-cell.sparql +++ b/extra/ucsc_encode_submission/find-lib-by-cell.sparql @@ -6,11 +6,12 @@ PREFIX libraryOntology: SELECT distinct ?liburn ?cell ?replicate ?subid ?name ?submission_date WHERE { - ?subid libraryOntology:date ?submission_date ; - ucscSubmission:name ?name . - OPTIONAL { ?subid ucscSubmission:library_urn ?liburn . + ?subid ucscSubmission:name ?name . + OPTIONAL { ?subid ucscSubmission:library_urn ?liburn ; + libraryOntology:date ?submission_date . ?liburn libraryOntology:cell_line ?cell ; libraryOntology:replicate ?replicate . } #filter(?submission_date > "2011-04-01T00:00:00Z"^^xsd:dateTime) + #filter(!bound(?liburn)) } ORDER BY ?submission_date ?cell ?replicate ?liburn -- 2.30.2