aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorzsloan2019-11-13 17:35:53 -0600
committerzsloan2019-11-13 17:35:53 -0600
commit725e6f7fe502b87f9ed4906de3842865bcc5cc9d (patch)
tree5a5970705ef702ceaf90fc23c5c70576dbfa69f8
parent072b8b9225a2ea4f8d8f4dba88eedab3f5593023 (diff)
downloadgenenetwork2-725e6f7fe502b87f9ed4906de3842865bcc5cc9d.tar.gz
Fixed issue that caused a couple REST API queries to not work
-rw-r--r--wqflask/wqflask/api/router.py3
1 files changed, 2 insertions, 1 deletions
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}"