Hi
how can i remove a large amount of holds without running the expire hold code report? (as its not set up yet.)
it is tedious removing the holds one by one.
any ideas??
Many Thanks,
Robert
Hi Robert
Do you mean holds for just one concert? If so you can right click and select the entire area on the seat map that you want to remove the holds from, then sekect Block Selection: Holds. Then in the Expire Hold Codes box, choose ALL (or whichever hold code you want to remove if it's just one type) and expire all.
Hope that helps - try it in your Test environment first to make sure you get it right as I don't think it's reversable!
Siobhan
Great! thats worked perferctly.
will save me alot of time.
Many thanks.
Hi All,
All the Hold codes are sitting in a table called TX_PERF_HC.
If you delete a record from this table, the hold code of that seat will be removed.
Not every seat has a hold code, but every HC record has a seat.
SELECT perf_no, seat_no, hc_no, priority, start_dt, end_dt, session_no FROM TX_PERF_HC have fun Ben
SELECT
perf_no, seat_no, hc_no, priority, start_dt, end_dt, session_no
FROM
TX_PERF_HC
have fun
Ben