scheduled reminder: activity reminder with choose recipients option limits to activity targets
To reproduce:
- create a scheduled reminder of type activity with a type/status as desired
- in the recipients field, select "choose recipient(s)" and select a contact. for the purpose of testing, choose a delivery date of today
- create an activity matching the type/status and dated today. the target should be someone other than the contact selected in 2
- trigger the reminder
No reminder is sent. The selected contact does not receive the email and no activity is created. The issue is that the query used to retrieve matching activities applies the recipient contact filter to the table joined for activity targets. So the reminder is not sent unless the recipient is also a target. It effectively applies the selection as a limiting clause instead of allowing the message to be sent to anyone.