Scheduled Reminder limited by Participant Role fails if any participant has multiple roles
Steps to replicate
- Register someone for the Rainforest Cup. Assign multiple roles.
- Create a scheduled reminder. Limit it by participant role. See screenshot below.
- Trigger the "Send Scheduled Reminders" job.
- Job doesn't crash.
[nativecode=1292 ** Truncated incorrect DOUBLE value: '1^A2']"]
This happens because the WHERE clause is using
IN but for multi-valued fields you need
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information