|
JacquesMivi
|
June 6, 2017 at 2:12 pm
Hello,
How can I have a list of attendees with this request
Fields : Ticket Name – Attendee email – Attendee – Number of reservation (REG_group_size ?)
Group By : Ticket Name, Attendee email
I can’t use REG group size because it can have the value of “2” if a person book for two different tickets on the same registration.
Thanks a lot
|
|
JacquesMivi
|
June 6, 2017 at 2:53 pm
OK. At the end I have use a custom request with :
"GROUP BY SUBSTRING(REG_code, 1, 9) "
Its, for the moment, my best way to have results with all the configurations available.
|
|
Josh
|
June 8, 2017 at 8:02 am
Hi JacquesMivi,
For future reference you can review the documentation on the model system for any other custom queries you build:
https://github.com/eventespresso/event-espresso-core/blob/master/docs/G–Model-System/model-querying.md
|
