evenparticipants detail list contains much to much status
Created by: johanvandyck
On the event detail page one gets a detailed list of the participants: name, gender, fee paid and status., However the list simply prints "all participants", not the "participants who will (likely) attend the event". It will display test users, deleted user,...
The query used is found in /civisualize-master/queries/eventparticipants.json ------------------- begin json ---------------------- {"query":"SELECT contact.display_name, contact.birth_date, contact.contact_type, contact.gender_id, participant.status_id, participant.fee_amount, participant.fee_currency, participant.register_date from civicrm_participant as participant INNER JOIN civicrm_contact as contact on participant.contact_id = contact.id and contact.is_deleted=0 where participant.event_id=%1;","params":{"1":{"name":"eventid","type":"Integer"}}} ------------------ end json ----------------------------- It is a good ideau to exclude test users: ----------------- adapted json ------------------------- {"query":"SELECT contact.display_name, contact.birth_date, contact.contact_type, contact.gender_id, participant.status_id, participant.fee_amount, participant.fee_currency, participant.register_date from civicrm_participant as participant Im' INNER JOIN civicrm_contact as contact on participant.contact_id = contact.id and contact.is_deleted=0 where participant.event_id=%1 and participant.is_test=0","params":{"1":{"name":"eventid","type":"Integer"}}} ------------------- adapted json ------------------------------ I'm not familiar with query writing, but is should be a good idea to include the civi concept "count as participant". Only the status which count for the participants list should be shown here.
Regards
Johan.