From a4b32dee1b1b638ab60c56df27ace221d6a77c3a Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Mon, 17 Mar 2025 13:49:35 -0500
Subject: Include InbredSetId: Useful for querying data.

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

(limited to 'uploader')

diff --git a/uploader/phenotypes/models.py b/uploader/phenotypes/models.py
index e1ec0c9..98278e5 100644
--- a/uploader/phenotypes/models.py
+++ b/uploader/phenotypes/models.py
@@ -75,7 +75,7 @@ def dataset_phenotypes(conn: mdb.Connection,
                        limit: Optional[int] = None) -> tuple[dict, ...]:
     """Fetch the actual phenotypes."""
     _query = (
-        "SELECT pheno.*, pxr.Id AS xref_id, ist.InbredSetCode FROM Phenotype AS pheno "
+        "SELECT pheno.*, pxr.Id AS xref_id, pxr.InbredSetId, ist.InbredSetCode FROM Phenotype AS pheno "
         "INNER JOIN PublishXRef AS pxr ON pheno.Id=pxr.PhenotypeId "
         "INNER JOIN PublishFreeze AS pf ON pxr.InbredSetId=pf.InbredSetId "
         "INNER JOIN InbredSet AS ist ON pf.InbredSetId=ist.Id "
-- 
cgit v1.2.3