• Replies 3 replies
  • Subscribers 415 subscribers
  • Views 31 views
  • Users 0 members are here
Related

MOS attached to the perf

Harpreet Gangyan
$organization

HI,

Is there a way to access all MOS and their start and end date specific to the performance through database query?

Thanks

Harpreet

Parents
  • $organization
    Harpreet -
     
    Try looking at the tx_perf_pkg_mos table. I'm not sure exactly what information you need, but if you join this table to t_perf or t_inventory it should get you on the road to what you are asking for.
     
    - Heather

    Heather Laidlaw Kraft
    SEATTLE REPERTORY THEATRE

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Harpreet Gangyan
    Sent: Sunday, June 07, 2009 8:41 PM
    To: Heather Laidlaw Kraft
    Subject: [Tessitura Ticketing Forum] MOS attached to the perf

    HI,

    Is there a way to access all MOS and their start and end date specific to the performance through database query?

    Thanks

    Harpreet




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Reply
  • $organization
    Harpreet -
     
    Try looking at the tx_perf_pkg_mos table. I'm not sure exactly what information you need, but if you join this table to t_perf or t_inventory it should get you on the road to what you are asking for.
     
    - Heather

    Heather Laidlaw Kraft
    SEATTLE REPERTORY THEATRE

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Harpreet Gangyan
    Sent: Sunday, June 07, 2009 8:41 PM
    To: Heather Laidlaw Kraft
    Subject: [Tessitura Ticketing Forum] MOS attached to the perf

    HI,

    Is there a way to access all MOS and their start and end date specific to the performance through database query?

    Thanks

    Harpreet




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Children
No Data