From 875debdb852557bc8f6c68cbb85f9d9d92449ba0 Mon Sep 17 00:00:00 2001
From: zsloan
Date: Sat, 27 Jul 2024 18:34:25 +0000
Subject: Include CaseAttribute.InbredSetId in the query that fetches case
 attributes

Previously issues could occur if a difference InbredSet had the same CaseAtribute Id
---
 gn2/wqflask/show_trait/SampleList.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'gn2/wqflask/show_trait')

diff --git a/gn2/wqflask/show_trait/SampleList.py b/gn2/wqflask/show_trait/SampleList.py
index 64909d6e..200ff793 100644
--- a/gn2/wqflask/show_trait/SampleList.py
+++ b/gn2/wqflask/show_trait/SampleList.py
@@ -132,7 +132,8 @@ class SampleList:
                 "CaseAttribute, CaseAttributeXRefNew WHERE "
                 "CaseAttributeXRefNew.CaseAttributeId = CaseAttribute.CaseAttributeId "
                 "AND CaseAttributeXRefNew.InbredSetId = %s "
-                "ORDER BY CaseAttribute.CaseAttributeId", (str(self.dataset.group.id),)
+                "AND CaseAttribute.InbredSetId = %s "
+                "ORDER BY CaseAttribute.CaseAttributeId", (str(self.dataset.group.id),str(self.dataset.group.id))
             )
 
             self.attributes = {}
-- 
cgit v1.2.3