• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 0 views
  • Users 0 members are here
Related

Stupid Question of the Day...

Matt Gonzales
$organization

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.

Parents
  • Former Member
    Former Member $organization

    And don't forget my favorite table, t_order_seat_hist.

    select h.id
    from t_order_seat_hist h with (nolock)
    join t_perf p with (nolock) on h.perf_no = p.perf_no
    join tr_price_type t with (nolock) on h.price_type = t.id
    where
    h.customer_no = 9599
    and h.event_code = 26                -- Payment paid, from tr_event_code
    and h.pkg_no = 0                    -- no package seats
    and p.season = 7
    and t.price_type_category in (2, 3) -- Standard and Discount, from tr_price_type_category

Reply
  • Former Member
    Former Member $organization

    And don't forget my favorite table, t_order_seat_hist.

    select h.id
    from t_order_seat_hist h with (nolock)
    join t_perf p with (nolock) on h.perf_no = p.perf_no
    join tr_price_type t with (nolock) on h.price_type = t.id
    where
    h.customer_no = 9599
    and h.event_code = 26                -- Payment paid, from tr_event_code
    and h.pkg_no = 0                    -- no package seats
    and p.season = 7
    and t.price_type_category in (2, 3) -- Standard and Discount, from tr_price_type_category

Children
No Data