Event participant role filter not working in Participant list report
Participant list report with Event participant role filter could show more rows.
Reproduction steps
- Create new participant role with id 11 (or 10, 21,...).
- Register new participant to event with this new role
- Show Participant list report on this event
- Use Participant Role filter to show only Attendees (id of attendee role is 1)
- In report will you see also participant with new role with id 11
Current behaviour
If you use Participant Role filter in Participant list report, that will be work like that: role.id LIKE '%1%'
and not like role.id = '1'
.
Expected behaviour
Report should show only exact role.
Environment information
- CiviCRM: _Master/5.37.0/5.33.2