summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorAlexander Tumin <iamtakingiteasy@eientei.org>2023-02-07 15:30:07 +0300
committertusooa <tusooa@kazv.moe>2023-02-20 12:27:50 -0500
commitc3a07035646b255bc5f33743d13defbaa69d9991 (patch)
tree6074da3cce476dca37d52a68e9aa786ed5e4cfa3 /lib
parent8e8a0f005cddf6b2cd1535ad634ac8cb8d0ca42e (diff)
downloadpleroma-c3a07035646b255bc5f33743d13defbaa69d9991.tar.gz
pleroma-c3a07035646b255bc5f33743d13defbaa69d9991.zip
Require related object for notifications to filter on content
Diffstat (limited to 'lib')
-rw-r--r--lib/pleroma/notification.ex1
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/pleroma/notification.ex b/lib/pleroma/notification.ex
index 60c1a80ba..48d467c59 100644
--- a/lib/pleroma/notification.ex
+++ b/lib/pleroma/notification.ex
@@ -178,6 +178,7 @@ defmodule Pleroma.Notification do
from([_n, a, o] in query,
where:
fragment("not(?->>'content' ~* ?)", o.data, ^regex) or
+ fragment("?->>'content' is null", o.data) or
fragment("?->>'actor' = ?", o.data, ^user.ap_id)
)
end