From 48cebe69811419f69f658c56e811f70b25fcec5d Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Thu, 12 Oct 2023 10:21:03 +0300
Subject: CaseAttributes: Bug: Fix query.

---
 wqflask/wqflask/show_trait/SampleList.py | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/wqflask/wqflask/show_trait/SampleList.py b/wqflask/wqflask/show_trait/SampleList.py
index 0f99243e..b5110dcd 100644
--- a/wqflask/wqflask/show_trait/SampleList.py
+++ b/wqflask/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 = {}
-- 
cgit v1.2.3