If someone mistakenly marks a seat attended when stubs are being scanned, is there a way to fix that? We aren't set up yet for scanning tix when people enter the theater, so we have to manually do it with a handheld scanner when the show is over, and once in a while, errors are made.
Hi Regina,
When I've had to "unscan" a ticket the process I've used is to delete the "Attended" (#22) event from T_ORDER_SEAT_HIST and update the TX_PERF_SEAT.available_ind = 0 for the ticket.
Regards,
Sean
Hi Sean,
I'm trying to do what you have put here and able to do it in SQL but was wondering if you can clarify the "TX_PERF_SEAT.available_ind=0" statement. Are you updating the field to "0" or a different number? When I look in my DB, most of the time that field is already "0". Any further direction you can give would be greatly appreciated as we've had some issues scanning tickets wrongly because of scanning issues and having to manual enter on NSCAN. That is being fixed but it would be great to clear up any mistakes we've had.
Thank you,Justin