Skip to content
Snippets Groups Projects

[JES] Add ordering to blacklists for consistency

Merged Jason Salyers requested to merge jsalyers-order-blacklists into develop
2 files
+ 3
3
Compare changes
  • Side-by-side
  • Inline
Files
2
@@ -8,11 +8,11 @@ SELECT observer_accounts.id AS observer_id,
JOIN hive_accounts following_accounts ON ((hive_follows.following = following_accounts.id)))
JOIN hive_accounts observer_accounts ON ((hive_follows.follower = observer_accounts.id)))
WHERE hive_follows.blacklisted
UNION
UNION ALL
SELECT observer_accounts.id AS observer_id,
following_accounts.id AS blacklisted_id,
following_accounts.name AS blacklisted_name,
string_agg(('blacklisted by '::text || (indirect_accounts.name)::text), ','::text) AS source
string_agg(('blacklisted by '::text || (indirect_accounts.name)::text), ','::text ORDER BY indirect_accounts.name) AS source
FROM (((hive_follows hive_follows_direct
JOIN hive_follows hive_follows_indirect ON ((hive_follows_direct.following = hive_follows_indirect.follower)))
JOIN hive_accounts following_accounts ON ((hive_follows_indirect.following = following_accounts.id)))
Loading