Event rule trigger fires daily
This is another regression from !172 (merged) - this rule is triggered daily, so, e.g, participants receive an email multiple times.
The issue is in the main SQL statement, which is still checking against DATE(NOW())
to see if someone has already triggered this rule, so it triggers daily.
I'm actually not sure why we need to check against DATE(NOW())
at all - I believe it's implicit in the changes @mattwire made that this rule should only fire once per participant. If there's an existing civirule_rule_log
record with a matching rule_id
, contact_id
, and entity_id
, that should be sufficient, correct?