Only transform datasets with public > 0 and confidentiality < 1.

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>

1 files changed, 1 insertions, 1 deletions

diff --git a/examples/phenotype.scm b/examples/phenotype.scm
index c2564b6..57fd2c5 100755
--- a/examples/phenotype.scm
+++ b/examples/phenotype.scm
@@ -71,7 +71,7 @@
            (inner-join PublishFreeze "ON PublishFreeze.InbredSetId = InbredSet.Id")
            (left-join Publication "ON Publication.Id = PublishXRef.PublicationId")
            (left-join Phenotype "ON Phenotype.Id = PublishXRef.PhenotypeId"))
-          "WHERE InbredSet.public > 0")
+          "WHERE InbredSet.public > 0 AND PublishFreeze.public > 0 AND PublishFreeze.confidentiality < 1")
   (triples (let ((post-abbrev (blank-p (field Phenotype Post_publication_abbreviation)))
                  (pre-abbrev (blank-p (field Phenotype Pre_publication_abbreviation)))
                  (post-desc (blank-p (field Phenotype Post_publication_description)))