Hi all,
I understand we have Tessitura ticket numbers and Tessitura generated barcodes.
If we sent out 100 prepaid tickets, but want to see which one of those tickets actually entered the building. How would we do so?
For example, "Hey I have this barcode 12345, can you tell me if this is used yet?"
The seat status is "ticketed", but does that change to "entered house" when it's scanned?
Is there a table that shows a history of barcode scans?
-Allan
Hi Allan!
The seat status in your orders won't change, but you can view attendance history within the Ticket History tab (it has its own radio button) of the constituent's account. If you want to pull some fun data bits with SSMS, the table you're looking for is called T_ATTENDANCE. You can check their attendance date/time, and see where (or by whom, depending on how you use your scanners) they were scanned in based on the device used. The table also does include ticket_no, so you can pull just one ticket at a time if need be.
Best,
Darryl
Awesome! Thanks so much Darryl! I wish the attendance history referenced the ticket numbers though (unless I'm missing it somewhere).. but I can grab that from T_Attendance.
Thanks,-Allan
You can also see whether a specific ticket has been marked attended in the order itself, using the Order History tab of Order Details. Once a ticket's scanned, it gets an Attended record, sequenced after the Printed record, which does reference the specific ticket number. Only one Attended record gets written, based on the first successful scan for the ticket, so if you are allowing multiple scans per barcode, you will not see an Attended record in the application for each scan.