• Replies 3 replies
  • Subscribers 415 subscribers
  • Views 32 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 Reply Children
  • $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!