Support

Home Forums Event Espresso Premium Get total check-ins of all attendants

Get total check-ins of all attendants

Posted: September 6, 2016 at 2:06 am


Beagle

September 6, 2016 at 2:06 am

Hi Team EE(4),

I was wondering if it is possible to get a table/list where it shows the total check-ins for all the datetimes of my event. So, on the left side the attendants, and on the right the total amount of check-ins. If this is too complicated, is it possible to let me know how and where this data is stored so I can call it?

Hope to hear from you, and many thanks in advance. Support has always been superb so far!

Best,

Mattias


Josh

  • Support Staff

September 7, 2016 at 7:21 am

Hi Mattias,

The date times of an event are stored in the _esp_datetime table.
The attendee records are stored in the _esp_registration table, and the checkins are stored in the _esp_checkin table. There’s some information in the developer documentation that explains how to use EE4’s model system to query data from the tables:

https://github.com/eventespresso/event-espresso-core/blob/master/docs/G–Model-System/model-querying.md
https://github.com/eventespresso/event-espresso-core/blob/master/docs/G–Model-System/using-ee4-model-objects.md


Beagle

September 7, 2016 at 3:46 pm

Awesome, I’ll give that a shot and close this topic for now. If I write something others might enjoy I will share it here.

Thanks,

Mattias

The support post ‘Get total check-ins of all attendants’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso