[Chandler] contact reminders showing up twice in dashboard => all planned reminders

[cmpickle]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github (I've searched it).
• I agree to follow Monica's Code of Conduct.

Bug description

When I create a reminder date in Chandler it shows up twice in the reminder screen in Dashboard => all planned reminders. I checked in the DB and there is only a single contact_reminder entry for each.

Steps to reproduce

1. Create a new Chandler instance
2. create a contact
3. add an important date with the yearly reminder checked
4. go to dashboard => all planned reminders
5. Each reminder date will show up twice

Expected behavior

1. Create a new Chandler instance
2. create a contact
3. add an important date with the yearly reminder checked
4. go to dashboard => all planned reminders
5. Each reminder date should show up once

Environment

Your own self-hosted instance (v5 a.k.a chandler version or main branch)

Version of Monica

5.0.0-beta.4

Installation method

Docker image

Web server

Apache

Database engine version

MySQL

Additional info

No response

[cmpickle]

I see where the issue comes from. In the table contact_reminder_scheduled there is a reminder created per notification channel, because of this it show twice in that view. Instead of pulling from that table to show the reminders to the UI it should probably be pulling from contact_reminders

[CodeLeom]

Can this issue be assigned to me?