commit: 3c3933e40bce7001b5025bf2e05412dd9c128f0f
parent: 7e9f14bf3ca95fda9042e10b44b80d8441fa3c42
Author: lain <lain@soykaf.club>
Date: Sun, 13 May 2018 11:58:03 +0200
Unlisted fetching: Reverse logic
Generates a faster query.
Diffstat:
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/lib/pleroma/web/activity_pub/activity_pub.ex b/lib/pleroma/web/activity_pub/activity_pub.ex
@@ -327,7 +327,7 @@ defmodule Pleroma.Web.ActivityPub.ActivityPub do
activity in query,
where:
fragment(
- "(?->'to' \\?| ?)",
+ "not (coalesce(?->'cc', '{}'::jsonb) \\?| ?)",
activity.data,
^["https://www.w3.org/ns/activitystreams#Public"]
)