diff options
| -rw-r--r-- | wqflask/wqflask/show_trait/SampleList.py | 6 |
1 files 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 = {} |