Clear cancelled bookings from database.

Hello,

Within Community Builder I have a table which shows the following information for the logged in user.

1. Event required? (Yes/No)
2. Event title
3. Event attended? (Yes/No)
4. Event date
5. Expiry date of training covered in the event.

All these fields are self populating using SQL queries and everything is working as it should.
However I have been testing and discovered an issue.

If a user registers for an event, then cancels that registration but re-books for the same event, the eb_registrants table in the database holds the cancelled registration and creates a new registration.

I therefore need to delete the row from the eb_registrants table where the status is "cancelled" to allow the SQL queries to extract the correct date and calculate the expiry date.

So, can you tell me the name of the column I need to reference in order to match against cancelled bookings please?
Having searched every column within eb_registrants table I can only imagine it is the "Published" column as that seems to reflect different states of a registration.

Many thanks in advance for your help with this.

Regards,
Julian.

Hi Julian

Yes. It's published column. When the registration record is cancelled, that column will have value = 2

Hope that helps

PS: In the future, please post your question in Events Booking forum category