Get Attendees by Event

[websource]

Hi there

Could you provide me a SQL Statement to get the Attendees for a specific Event outside of WP?
Or you may help me by building one?

Thanks

[Barry]

Hi @websource,

Thanks for getting in touch!

While custom development generally isn’t something we can go to deep with, I’d be happy to summarize how things are structured:

• Each (EDD) ticket lives in the post table and is of the tribe_eddticket type
• Each of these has a piece of postmeta data associated with it – _tribe_eddticket_event – linking it to a specific event
• Similarly, it is linked to an EDD order via _tribe_eddticket_order

By following these connections you should be able to obtain order and ticket (attendee) data for every event 🙂

[websource]

Hi @Barry

Thanks for helping me out here!

Some Questions for this Case:
– How should we Cancel an Attendee whos not coming?
At the Moment i just deleted the Payment Data in EDD and got a Line with a red sign in the EDD Event-AttendeeList, which said me that i cancelled someone in this event. As upon your help i saw that when i search for Attendees on a Event like this ” SELECT * FROM wp_postmeta WHERE meta_key = ‘_tribe_eddticket_event’ AND meta_value = 3415″ <– last one would then be Event_ID for some Co-Readers.. i see also the Lines cancelled ones (I know theres no meta then)

Just if i delete the attendee also on the Attendees Page this DatabaseEntry goes away. So we have to delete both (attendee at attendee-list in event and payment data in EDD) if we want to cancel an attendee?

[Barry]

Hi @websource,

The general recommended procedure for cancellations is to edit the order (via Downloads → Payment History) and change the status for the order in question (to “Cancelled”).

The matching entries in the attendee list should then also be flagged up as having been cancelled – which can be useful if someone nonetheless attends and presents their ticket at the door (as you have a record of what happened).

If you need to delete entries altogether, again you can delete the order from the screen I just referenced and delete the attendee entries from the actual attendee list (there is a “Delete” bulk action).

Does that help?

[websource]

After some Work, its done. Thanks!!

[Barry]

Awesome!

[Author]

Posts