We are in the process of rezoning. I need a query that will list all seat numbers of all unpaid and unreserved E holds not assigned to any patron number, grouped by Performance. I will need to run this query every day so we can rezone the price for those specific seats.
Eventually, I'd like a report that our BO Manager can run through Tessitura each day.
I appreciate your sql-scripting assistance! Thanks!
Hi Randall,
Have you tried the canned report "Hold Code Report (New)"I may be misunderstanding what you need but it seems like it would accomplish what you are trying to do.