Answers.Body: <p>If your fields are Searchable then they should show up as expandable sections in the Event Participants List Report</p>
  <p>If they are not showing there then suggest you go to your Custom Fields and confirm if you set them to be Searchable or not.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-29T05:26:27.783Z
Answers.Text: I am just learning the system and didn't see that setting. Thank you it works now. BTW the extended reports is throwing an error: Undefined index: email_on_hold_value in /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Utils/Report.php on line 500. How to fix?
Answers.UserDisplayName: P a u l
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-11-29T03:40:57.637Z
Answers.LastActivityDate: 2022-11-29T03:40:57.637Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>My event has custom data extending participants. I can't find any way to report, search or sort on the custom data.</p>
  <p>I have found the relevant tables for the options but the sql statement will be complex. I'd prefer to find a report already written. If I can't I could write my own stand alone page in php and query the database directly.</p>
  <p>Edit: Here is the sql to show dinner preferences for each conference participant. I hard coded a couple of id numbers to save time.</p>
  <p>SELECT civicrm_contact.display_name, civicrm_email.email, civicrm_phone.phone, civicrm_option_value.name
  FROM civicrm_participant, civicrm_contact, civicrm_phone, civicrm_email, civicrm_value_rpc_2023_meal_24, civicrm_option_value
  where civicrm_participant.event_id=5
  and civicrm_participant.status_id=1
  and civicrm_participant.contact_id = civicrm_contact.id
  and civicrm_participant.contact_id = civicrm_phone.contact_id
  and civicrm_value_rpc_2023_meal_24.entity_id=civicrm_participant.id
  and civicrm_option_value.option_group_id = 124
  and civicrm_value_rpc_2023_meal_24.meal_preference_44 = civicrm_option_value.value
  and civicrm_email.contact_id = civicrm_participant.contact_id</p>
  
Tags: <participants>
Title: How to extract or list participant custom data?
ThreadText: # How to extract or list participant custom data?
  
  (Asked by: username_0 on 2022-11-29)
  
  My event has custom data extending participants. I can't find any way to report, search or sort on the custom data.
  
  I have found the relevant tables for the options but the sql statement will be complex. I'd prefer to find a report already written. If I can't I could write my own stand alone page in php and query the database directly.
  
  Edit: Here is the sql to show dinner preferences for each conference participant. I hard coded a couple of id numbers to save time.
  
  SELECT civicrm\_contact.display\_name, civicrm\_email.email, civicrm\_phone.phone, civicrm\_option\_value.name
  FROM civicrm\_participant, civicrm\_contact, civicrm\_phone, civicrm\_email, civicrm\_value\_rpc\_2023\_meal\_24, civicrm\_option\_value
  where civicrm\_participant.event\_id=5
  and civicrm\_participant.status\_id=1
  and civicrm\_participant.contact\_id = civicrm\_contact.id
  and civicrm\_participant.contact\_id = civicrm\_phone.contact\_id
  and civicrm\_value\_rpc\_2023\_meal\_24.entity\_id=civicrm\_participant.id
  and civicrm\_option\_value.option\_group\_id = 124
  and civicrm\_value\_rpc\_2023\_meal\_24.meal\_preference\_44 = civicrm\_option\_value.value
  and civicrm\_email.contact\_id = civicrm\_participant.contact\_id
  
  **Tags:** participants
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-11-29. Score: 0 | Accepted answer
  
  If your fields are Searchable then they should show up as expandable sections in the Event Participants List Report
  
  If they are not showing there then suggest you go to your Custom Fields and confirm if you set them to be Searchable or not.
  
  > **Comments:**
  > **username_0**: I am just learning the system and didn't see that setting. Thank you it works now. BTW the extended reports is throwing an error: Undefined index: email_on_hold_value in /home/noyb/public_html/wp-content/plugins/civicrm/civicrm/CRM/Report/Utils/Report.php on line 500. How to fix?  
  
  ---
  
  