diff options
| author | zsloan | 2024-07-27 18:34:25 +0000 |
|---|---|---|
| committer | Alexander_Kabui | 2024-08-28 15:02:46 +0300 |
| commit | b14437638422d54e06bb6c1779b8c724f024aa1c (patch) | |
| tree | 2ee8526f81869c7909d3042d35fddfa119fbef74 | |
| parent | 7929c7c5a9939906d5dfc1df101df59fc53def60 (diff) | |
| download | genenetwork2-b14437638422d54e06bb6c1779b8c724f024aa1c.tar.gz | |
Include CaseAttribute.InbredSetId in the query that fetches case attributes
Previously issues could occur if a difference InbredSet had the same CaseAtribute Id
| -rw-r--r-- | gn2/wqflask/show_trait/SampleList.py | 3 |
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 = {} |