T_ORDER_SEAT_HIST and Reservations

By reservations, do you mean seated or unseated?  The portion of the case statement “seat_no > 0” is only picking up seated reservation increments and decrements.  Looking at unseated reservation changes aggregated over time is not possible using order seat history as the movement from “unseated to seated” is not captured in the auditing.

Also note that these entries are based on exact date, not order date.

The code you have below doesn’t seem to be correct as well.  You have a -1 for @event_code_new_paid, which should be +1.  Without seeing the rest of your code, I’m not quite sure where else to lead you.

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick Insell
Sent: Monday, March 19, 2012 10:46 AM
To: Ryan Creps
Subject: [Tessitura Technical Forum] T_ORDER_SEAT_HIST and Reservations

Hi Guys

We are trying to compare two Groups on sale dates against each other and the total number of Reservations that where made on one particular day.  I think that the only way that we can get the total number of reservations for a day is using T_ORDER_SEAT_HIST but I'm having problems getting correct figures.

Have any of you managed to put together a script that will give you an accurate number of reserves from T_ORDER_SEAT_HIST.  I have tried looking at the RP_TICKET_SALES_BY_PERIOD report to get a good understanding of how to work out the roughly the correct figures but they aren't exact! 

The closed I have got is using but I know this isn't right.

CASE
 when event_code = @event_code_new_paid and h.seat_no > 0 then -1
 when event_code = @event_code_new_unpaid and h.seat_no > 0 then -1
 when event_code = @event_code_returned and h.seat_no > 0 then -1
 when event_code = @event_code_released and h.seat_no > 0 then -1
 when event_code = @event_code_reserved and h.seat_no > 0 then 1
END 

Any pointers would be great

Thanks

Nick

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!