From 575ffb39badc5ebee722b3ff02be7b742de49b0d Mon Sep 17 00:00:00 2001 From: Diane Trout Date: Tue, 19 Jul 2011 17:38:27 -0700 Subject: [PATCH] Make searching library & cell line more robust to missing data and add example to limit to a date range, to help with status reports. --- .../ucsc_encode_submission/find-lib-by-cell.sparql | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) 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: PREFIX rdfs: PREFIX ucscSubmission: PREFIX 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 -- 2.30.2