What would be the simplest way (pseudocode is fine) to ask Tessitura if a particular customer number was a single ticket buyer for a particular season?
My only hangup is which table would definitively have that info. I can write the logic, but I get so easily confused about what tables hold what information when it comes to ticketing.
Thanks for your help, guys.
Trivia Carrot on Stick: Elephants are the only mammal (besides humans) that can stand on its head.
Simplest way would be lt_tkt_hist ->tr_price_type (assuming your tkt hist has price type) where the pt category/group/ however your org establishes what is "single" and season= (the season in question).
If your tkt hist doesn't contain pricetype, then I'd say
order -> sublineitem
-> perf (for the season)
->price_type
And don't forget my favorite table, t_order_seat_hist.
select h.idfrom t_order_seat_hist h with (nolock)join t_perf p with (nolock) on h.perf_no = p.perf_nojoin tr_price_type t with (nolock) on h.price_type = t.idwhereh.customer_no = 9599and h.event_code = 26 -- Payment paid, from tr_event_codeand h.pkg_no = 0 -- no package seatsand p.season = 7and t.price_type_category in (2, 3) -- Standard and Discount, from tr_price_type_category