fefrei
(Felix Freiberger)
1
This badge detects whether a user has enabled mailing list mode:
SELECT u.id user_id, current_timestamp granted_at
FROM users u
WHERE mailing_list_mode = true
AND (:backfill OR u.id IN (:user_ids))
It should trigger when a user is created or edited.
1 Like
nathank
(Nathan Kershaw)
2
That query is broken; here is an updated version for getting those on Mailing List Mode:
SELECT user_id, current_timestamp granted_at
FROM user_options
WHERE mailing_list_mode = true
AND (:backfill OR user_id IN (:user_ids))
5 Likes