From 2fa16a0f9a8de13cdaed3a5332405f9fc1b62f17 Mon Sep 17 00:00:00 2001 From: Santo Cariotti Date: Thu, 13 Oct 2022 22:39:35 +0200 Subject: Add ordering for users list --- src/models/user.rs | 1 + 1 file changed, 1 insertion(+) (limited to 'src/models') diff --git a/src/models/user.rs b/src/models/user.rs index 3f7a172..0aaa730 100644 --- a/src/models/user.rs +++ b/src/models/user.rs @@ -130,6 +130,7 @@ impl User { let pool = unsafe { get_client() }; let rows: Vec = sqlx::query_as( r#"SELECT id, name, email, username, is_staff, avatar FROM users + ORDER BY id DESC LIMIT $1 OFFSET $2 "#, ) -- cgit v1.2.3-71-g8e6c