• Replies 3 replies
  • Subscribers 415 subscribers
  • Views 30 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

  • $organization

    That one is TX_PERF_PKG_MOS.  Join to perf_no for performance mos details, and pkg_no for package mos details.  Make sure to exclude perf_no 0 as the table stores a 0 not a null for perf_no when there is a pkg_no present. 

    For further details on tables in Tessitura the best resource is the Table Structures document.  http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Tessitura%20Table%20Structures.aspx

    Best,

    Anna

  • $organization in reply to Anna Wessely (Past Staff Member)

    Thanks

     

    Harpreet Gangyan | Database Analyst

    THE

    Level 4 TSB Building| PO BOX 5143, Wellesley Street | Auckland 1411, New Zealand
    T: +64 9 357 3351     | F: +64 9 357 3359 | www.the-edge.co.nz

    Please consider the environment before you print this email.

     

    Notice: This email is confidential. If it is not intended for you please do not read, distribute or copy the email or any attachments.
    Please notify the sender that you have received the message in error and delete the

    original message and any attachments.
    Please note that any views expressed in this email may be those of the individual sender and may not necessarily reflect the views of THE EDGE®.

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Anna Wessely
    Sent: Monday, 8 June 2009 16:16
    To: Harpreet Gangyan
    Subject: Re: [Tessitura Ticketing Forum] MOS attached to the perf

     

    That one is TX_PERF_PKG_MOS.  Join to perf_no for performance mos details, and pkg_no for package mos details.  Make sure to exclude perf_no 0 as the table stores a 0 not a null for perf_no when there is a pkg_no present. 

    For further details on tables in Tessitura the best resource is the Table Structures document.  http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/Tessitura%20Table%20Structures.aspx

    Best,

    Anna

    From: Harpreet Gangyan <bounce-harpreetsinghgangyan5939@tessituranetwork.com>
    Sent: 6/7/2009 10:36:41 PM

    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!

  • $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!