Hey all,
I'm working on a SQL select query of ticketing and seat information, and I'd like to be able to add the n-scan ticket number to the query, but for the life of me I can't find where the number lives in the database. I know it's possible to get the number from the Order Export Utility when it's run in individual mode, but Does anyone have a table or view that they know it lives on?
Dee Bierschenk said:I'd like to be able to add the n-scan ticket number to the query, but for the life of me I can't find where the number lives in the database. I
I assume you refer to what is stored in the column 'ticket_no" in the tables T_NSCAN_EVENT_CONTROL and T_ATTENDANCE (under v15.2, FYI; not sure if any of this changes under v16).
If I'm not mistaken, the former will store a row for each attempted scan, and the latter is one row per ticket.