about summary refs log tree commit diff
path: root/examples/dump-probeset-metadata.scm
diff options
context:
space:
mode:
Diffstat (limited to 'examples/dump-probeset-metadata.scm')
-rwxr-xr-xexamples/dump-probeset-metadata.scm3
1 files changed, 2 insertions, 1 deletions
diff --git a/examples/dump-probeset-metadata.scm b/examples/dump-probeset-metadata.scm
index ae9931c..b3f4165 100755
--- a/examples/dump-probeset-metadata.scm
+++ b/examples/dump-probeset-metadata.scm
@@ -23,7 +23,8 @@
 (define-dump dump-probeset-metadata
   (tables (ProbeSetXRef
            (left-join ProbeSet "ON ProbeSetXRef.ProbeSetId = ProbeSet.Id")
-           (left-join ProbeSetFreeze "ON ProbeSetXRef.ProbeSetFreezeId = ProbeSetFreeze.Id")))
+           (left-join ProbeSetFreeze "ON ProbeSetXRef.ProbeSetFreezeId = ProbeSetFreeze.Id"))
+          "WHERE ProbeSetFreeze.public > 0 AND ProbeSetFreeze.confidentiality < 1")
   (schema-triples
    (gn:probesetData rdfs:range gn:probeset)
    (gn:hasProbeset rdfs:range rdfs:Literal))