aboutsummaryrefslogtreecommitdiff
path: root/src/guff.cr
diff options
context:
space:
mode:
authorPaul Duncan <pabs@pablotron.org>2016-05-26 00:57:06 -0400
committerPaul Duncan <pabs@pablotron.org>2016-05-26 00:57:06 -0400
commit9e73b3b2bd571b5f7dd752db80bc86f27d2300dd (patch)
treea15ef6d318b19a48dbcbd6bf7981a5cc83f031c7 /src/guff.cr
parenta5757765b0f5f17d7ab9916b6fe9c3127b41790b (diff)
downloadguff-9e73b3b2bd571b5f7dd752db80bc86f27d2300dd.tar.bz2
guff-9e73b3b2bd571b5f7dd752db80bc86f27d2300dd.zip
enable user list
Diffstat (limited to 'src/guff.cr')
-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)
",
}