From b593047fb14e432a87e79e3f7cd8bb299f99a4e3 Mon Sep 17 00:00:00 2001 From: Felix Ableitner Date: Fri, 19 Feb 2021 15:59:06 +0100 Subject: [PATCH] Order outbox by published, not id --- crates/db_queries/src/source/activity.rs | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/crates/db_queries/src/source/activity.rs b/crates/db_queries/src/source/activity.rs index ad71e88d..59e1754a 100644 --- a/crates/db_queries/src/source/activity.rs +++ b/crates/db_queries/src/source/activity.rs @@ -111,7 +111,7 @@ impl Activity_ for Activity { .sql(" AND activity.data -> 'object' -> 'object' ->> 'type' = 'Page'") .sql(" AND activity.data ->> 'actor' = ") .bind::(community_actor_id) - .sql(" ORDER BY activity.id DESC"), + .sql(" ORDER BY activity.published DESC"), ) .limit(20) .get_results(conn)?; -- 2.44.1