aboutsummaryrefslogtreecommitdiffstats
path: root/pydis_site
diff options
context:
space:
mode:
authorGravatar jchristgit <[email protected]>2024-03-02 11:42:40 +0100
committerGravatar GitHub <[email protected]>2024-03-02 11:42:40 +0100
commit1c6335bac7c357d8cd072bd5317339ac2fc20d3d (patch)
tree3b1ab78b6b9bcf9c0d7baae19aebf8fd6a55c8ea /pydis_site
parentMerge pull request #1232 from python-discord/feat/font-awesome-plugin (diff)
parentEnsure messages returned for metricity data do not match all excluded channels (diff)
Merge pull request #1240 from python-discord/fix-metricity-message-counts
Ensure messages returned for metricity data do not match all excluded channels
Diffstat (limited to 'pydis_site')
-rw-r--r--pydis_site/apps/api/models/bot/metricity.py6
1 files changed, 3 insertions, 3 deletions
diff --git a/pydis_site/apps/api/models/bot/metricity.py b/pydis_site/apps/api/models/bot/metricity.py
index f1277b21..7d5d5f0b 100644
--- a/pydis_site/apps/api/models/bot/metricity.py
+++ b/pydis_site/apps/api/models/bot/metricity.py
@@ -49,7 +49,7 @@ class Metricity:
WHERE
author_id = '%s'
AND NOT is_deleted
- AND channel_id != ANY(%s)
+ AND channel_id != ALL(%s)
""",
[user_id, EXCLUDE_CHANNELS]
)
@@ -77,7 +77,7 @@ class Metricity:
WHERE
author_id='%s'
AND NOT is_deleted
- AND channel_id != ANY(%s)
+ AND channel_id != ALL(%s)
GROUP BY interval
) block_query;
""",
@@ -147,7 +147,7 @@ class Metricity:
WHERE
author_id = ANY(%s)
AND NOT is_deleted
- AND channel_id != ANY(%s)
+ AND channel_id != ALL(%s)
AND created_at > now() - interval '%s days'
GROUP BY author_id
""",