Support

August 20, 2015 at 12:54 pm

Hi AJ, that parameter (answers to custom questions) is not currently available as an option for the [ESPRESSO_EVENT_ATTENDEES] shortcode.

—
Lorenzo

August 24, 2015 at 5:24 pm

Hi AJ,

So you likely already know the question ID (QST_ID) for the row you want to query from _esp_answer table to get the answer value (ANS_value). Is that about right?

I can see where you’d run into issues when using the shortcode because the [ESPRESSO_EVENT_ATTENDEES] shortcode is pulling data from the Contact/Attendee instead of the actual registration. Mostly because a contact/Attendee can have multiple registrations, so even if you get all the related registrations for that contact and loop through them, how do you know which registration ID is the right one?

With the above in mind, I guess I’d advise to not use the ESPRESSO_EVENT_ATTENDEES shortcode and instead do a query on the registrations for that event or ticket, then you’ll have the correct registration ID every time. Along with that, once you have the registration object, you can use the answer_value_to_question() method from the EE_Registration class.