diff options
| author |  Chris Lovering <[email protected]> | 2024-02-20 15:14:37 +0000 |
|---|---|---|
| committer | Chris Lovering <[email protected]> | 2024-02-20 15:21:54 +0000 |
| commit | 3bec3c32dea8ebb939f7e65916905161d8ded30c (patch) | |
| tree | 56195533005f65394e8e24044400d9fa55536c02 | |
| parent | Merge pull request #1238 from python-discord/dependabot/pip/pre-commit-3.6.2 (diff) | |
Ensure messages returned for metricity data do not match all excluded channels
Diffstat (limited to '')
| -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 """, |