Include CaseAttribute.InbredSetId in the query that fetches case attributes

Previously issues could occur if a difference InbredSet had the same CaseAtribute Id

1 files changed, 2 insertions, 1 deletions

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 = {}