diff options
author | 2024-03-02 11:42:40 +0100 | |
---|---|---|
committer | 2024-03-02 11:42:40 +0100 | |
commit | 1c6335bac7c357d8cd072bd5317339ac2fc20d3d (patch) | |
tree | 3b1ab78b6b9bcf9c0d7baae19aebf8fd6a55c8ea /pydis_site | |
parent | Merge pull request #1232 from python-discord/feat/font-awesome-plugin (diff) | |
parent | Ensure 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.py | 6 |
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 """, |