Participant Listing report filters incorrectly on role ID
This issue is identical to CRM-18803 except that CRM-18803 affected all other CiviReports with fields that stored values separated by CRM_Core_DAO::VALUE_SEPARATOR
. Those were fixed everywhere else by this PR. However, since the where()
in this report is overridden, it has its own copy of the regex which wasn't fixed.
I grepped and confirmed this is the only place where this needs to be fixed, and applied the same regex as the commit above.
To replicate this bug, you need at least ten participant roles. The first one's value should be 1
. Searching on this value will return any participant whose role BEGINS with a 1
(i.e. 10
, 11
, 100
, etc.) rather than just records whose participant role value IS 1.