|
Railpromo
|
January 9, 2017 at 12:53 pm
Dear team,
I’m building a custom ticket sales website whereby I’m querying the Event Espresso tables. I need to gather custom question’s answers, which I’m doing by querying tickets sold linked to a specific event, looking up the assigned registrations and in turn the question answers.
Now, when I go to the back-end, open a registration and set its status to Cancel, I would expect the REG_deleted field in prefix_esp_registration to be set to one. Nevertheless, it’s not; it remains set to 0. Could you tell me where I can find where it’s stored when a registration has been cancelled?
Furthermore, I would also like to know in which table an event title (so not the datetime title) is stored. Would you be so kind to answer that?
Many thanks in advance,
Best,
Luc
|
|
Tony
|
January 10, 2017 at 6:15 am
Hi there,
A registration with a status of Cancelled has not been deleted, its simply had its status set to cancelled so you would find this by looking at the STS_ID column for the registration.
For a cancelled registration this would be ‘RCN’ by default.
|
