aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xexamples/generif.scm2
1 files changed, 1 insertions, 1 deletions
diff --git a/examples/generif.scm b/examples/generif.scm
index 89e7fce..83f8632 100755
--- a/examples/generif.scm
+++ b/examples/generif.scm
@@ -138,7 +138,7 @@
(define-transformer ncbi-genewiki-entries
(tables (GeneRIF_BASIC
(left-join Species "USING (SpeciesId)"))
- "WHERE GeneRIF_BASIC.comment IS NOT NULL GROUP BY GeneRIF_BASIC.comment, GeneRIF_BASIC.createtime, GeneRIF_BASIC.VersionId, GeneRIF_BASIC.SpeciesId, GeneRIF_BASIC.TaxID")
+ "WHERE GeneRIF_BASIC.comment IS NOT NULL AND TRIM(GeneRIF_BASIC.comment) != '' AND TRIM(GeneRIF_BASIC.symbol) != '' GROUP BY GeneRIF_BASIC.comment, GeneRIF_BASIC.createtime, GeneRIF_BASIC.VersionId, GeneRIF_BASIC.SpeciesId, GeneRIF_BASIC.TaxID")
(schema-triples
(gnc:NCBIWikiEntry rdfs:subClassOf gnc:GeneWikiEntry)
(gnc:NCBIWikiEntry rdfs:comment "Represents GeneRIF Entries obtained from NCBI")