diff options
Diffstat (limited to 'gn2')
| -rw-r--r-- | gn2/wqflask/show_trait/SampleList.py | 6 |
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 = {} |