aboutsummaryrefslogtreecommitdiff
path: root/gn2
diff options
context:
space:
mode:
Diffstat (limited to 'gn2')
-rw-r--r--gn2/wqflask/show_trait/SampleList.py6
1 files changed, 3 insertions, 3 deletions
diff --git a/gn2/wqflask/show_trait/SampleList.py b/gn2/wqflask/show_trait/SampleList.py
index 111537c1..64fc8fe6 100644
--- a/gn2/wqflask/show_trait/SampleList.py
+++ b/gn2/wqflask/show_trait/SampleList.py
@@ -125,13 +125,13 @@ class SampleList:
# Get attribute names and distinct values for each attribute
with database_connection(get_setting("SQL_URI")) as conn, conn.cursor() as cursor:
cursor.execute(
- "SELECT DISTINCT CaseAttribute.Id, "
+ "SELECT DISTINCT CaseAttribute.CaseAttributeId, "
"CaseAttribute.Name, CaseAttribute.Description, "
"CaseAttributeXRefNew.Value FROM "
"CaseAttribute, CaseAttributeXRefNew WHERE "
- "CaseAttributeXRefNew.CaseAttributeId = CaseAttribute.Id "
+ "CaseAttributeXRefNew.CaseAttributeId = CaseAttribute.CaseAttributeId "
"AND CaseAttributeXRefNew.InbredSetId = %s "
- "ORDER BY CaseAttribute.Id", (str(self.dataset.group.id),)
+ "ORDER BY CaseAttribute.CaseAttributeId", (str(self.dataset.group.id),)
)
self.attributes = {}