diff options
| author | Munyoki Kilyungi | 2023-10-19 16:51:39 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2023-10-19 16:51:39 +0300 |
| commit | 3c06bf6f0006c637af5cea6839539769a4f229d1 (patch) | |
| tree | 9d863015934707ab60517c7b8b6da8050d3562f8 | |
| parent | 9ac9e77dc30b4d3957c2fc9fdf92b5e001fca170 (diff) | |
| download | gn-transform-databases-3c06bf6f0006c637af5cea6839539769a4f229d1.tar.gz | |
Remove un-necessary WHERE clause when dumping phenotypes.
* examples/phenotype.scm (phenotypes): Delete "WHERE" clause.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rwxr-xr-x | examples/phenotype.scm | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/examples/phenotype.scm b/examples/phenotype.scm index 2b1a3a9..6dd82f2 100755 --- a/examples/phenotype.scm +++ b/examples/phenotype.scm @@ -18,8 +18,7 @@ (tables (PublishXRef (left-join InbredSet "ON InbredSet.InbredSetId = PublishXRef.InbredSetId") (left-join Publication "ON Publication.Id = PublishXRef.PublicationId") - (left-join Phenotype "ON Phenotype.Id = PublishXRef.PhenotypeId")) - "WHERE PublishXRef.InbredSetId IN (SELECT PublishFreeze.InbredSetId FROM PublishFreeze)") + (left-join Phenotype "ON Phenotype.Id = PublishXRef.PhenotypeId"))) (schema-triples (gnt:abbreviation a owl:ObjectProperty) (gnt:abbreviation rdfs:domain gnc:Phenotype) |