# People receiving reminders even though they've accepted the policy

**URL:** <https://meta.discourse.org/t/people-receiving-reminders-even-though-theyve-accepted-the-policy/268730>\
**Category:** Product Support\
**Tags:** policy\
**Created:** [June 16, 2023, 3:58pm UTC](https://meta.discourse.org/t/people-receiving-reminders-even-though-theyve-accepted-the-policy/268730 "2023-06-16T15:58:53Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)\
**Post date:** [July 5, 2023, 5:16am UTC](https://meta.discourse.org/t/people-receiving-reminders-even-though-theyve-accepted-the-policy/268730/9 "2023-07-05T05:16:35Z")

</div>

Just to follow up here publically for future travellers. 🙂

I think something like this would allow you to check out the relevant information and see if a notification was sent after the policy had been accepted:

```sql
-- [params]
-- topic_id :topic_id

SELECT pp.id AS "Policy ID",
       pp.created_at AS "Policy Created",
       n.user_id,
       n.created_at AS "Last Notification Received",
       pu.accepted_at AS "User Accepted Policy",
       pu.revoked_at AS "User Revoked Policy",
       pu.expired_at AS "Policy Expired"
FROM notifications n
JOIN posts p ON p.topic_id = n.topic_id 
JOIN post_policies pp ON pp.post_id = p.id
LEFT JOIN policy_users pu ON pu.post_policy_id = pp.id AND pu.user_id = n.user_id
WHERE n.topic_id = :topic_id
  AND n.user_id > 0
ORDER BY n.user_id, pu.accepted_at

```

---

_[View the full topic](https://meta.discourse.org/t/people-receiving-reminders-even-though-theyve-accepted-the-policy/268730)._