From 346895669845b2778dbbae2638f44d1f8e5dd4c0 Mon Sep 17 00:00:00 2001
From: zsloan
Date: Thu, 17 Aug 2023 18:21:59 +0000
Subject: Fix fetch_trait query for phenotypes

---
 gn3/db/phenotypes.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'gn3/db')

diff --git a/gn3/db/phenotypes.py b/gn3/db/phenotypes.py
index 2b16b17..6c6e61b 100644
--- a/gn3/db/phenotypes.py
+++ b/gn3/db/phenotypes.py
@@ -116,7 +116,7 @@ def fetch_trait(conn: DBConnection, dataset_id: int, trait_name: str) -> dict:
         "FROM PublishFreeze AS pf INNER JOIN InbredSet AS iset "
         "ON pf.InbredSetId=iset.Id "
         "INNER JOIN PublishXRef AS pxr ON iset.Id=pxr.InbredSetId "
-        "WHERE pf.Id=%(dataset_id)s AND pxr.Id=%(trait_name)s")
+        "WHERE iset.Id=%(dataset_id)s AND pxr.Id=%(trait_name)s")
     with conn.cursor(cursorclass=DictCursor) as cursor:
         cursor.execute(
             query, {"dataset_id": dataset_id, "trait_name": trait_name})
-- 
cgit v1.2.3