From 725e6f7fe502b87f9ed4906de3842865bcc5cc9d Mon Sep 17 00:00:00 2001 From: zsloan Date: Wed, 13 Nov 2019 17:35:53 -0600 Subject: Fixed issue that caused a couple REST API queries to not work --- wqflask/wqflask/api/router.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/wqflask/wqflask/api/router.py b/wqflask/wqflask/api/router.py index e2e91d70..a6e56962 100644 --- a/wqflask/wqflask/api/router.py +++ b/wqflask/wqflask/api/router.py @@ -247,10 +247,11 @@ def get_dataset_info(dataset_name, group_name = None, file_format="json"): SELECT PublishXRef.Id, Phenotype.Post_publication_abbreviation, Phenotype.Post_publication_description, Phenotype.Pre_publication_abbreviation, Phenotype.Pre_publication_description, Publication.PubMed_ID, Publication.Title, Publication.Year - FROM PublishXRef, Phenotype, Publication, InbredSet + FROM PublishXRef, Phenotype, Publication, InbredSet, PublishFreeze WHERE PublishXRef.InbredSetId = InbredSet.Id AND PublishXRef.PhenotypeId = Phenotype.Id AND PublishXRef.PublicationId = Publication.Id AND + PublishFreeze.InbredSetId = InbredSet.Id AND PublishFreeze.public > 0 AND PublishFreeze.confidentiality < 1 AND InbredSet.Name = "{0}" AND PublishXRef.Id = "{1}" -- cgit v1.2.3