aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/guff.cr5
1 files changed, 3 insertions, 2 deletions
diff --git a/src/guff.cr b/src/guff.cr
index 7eb284a..6b842f8 100644
--- a/src/guff.cr
+++ b/src/guff.cr
@@ -1042,13 +1042,14 @@ module Guff
a.name,
a.email,
a.is_active,
- b.role
+ b.role,
+ b.name AS role_name
FROM users a
JOIN roles b
ON (b.role_id = a.role_id)
- ORDER BY LOWER(a.email)
+ ORDER BY LOWER(a.name)
",
}