Will Tessitura blow up if I change an order_dt with SQL?

Quick question - my box office has asked me to change an order_dt on a particular order for a customer, but the order has been saved, so it can't be modified any further from within Tessitura.

The question is, if I update the order_dt via the back end in T_ORDER, will it cause any issues that I don't know about?

 

Cheers,

 

Matt

Parents
  • Former Member
    Former Member $organization

    Good day, Matt

     

    We’re relatively new to Tessitura, making the final switch this past July.

    Then, in July, we completed a messy rollover process.

    Because of the messy process, we had many orders with a “bad” order date (and bad data in other fields).

     

    Using SQL, I updated *many* fields in T_ORDER to clean things up.

    Unsure how others will respond, but we haven’t seen any negative effects.

    It certainly resolved problems with T-Stats.  Mgmt is finally seeing something useful.

     

    Let me know if I can help, and …

     

    Good Luck

     

    Wendell Baskin

    Bass Hall – Fort Worth

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
    Sent: Thursday, August 29, 2013 02:23
    To: Wendell Baskin
    Subject: [Tessitura Technical Forum] Will Tessitura blow up if I change an order_dt with SQL?

     

    Quick question - my box office has asked me to change an order_dt on a particular order for a customer, but the order has been saved, so it can't be modified any further from within Tessitura.

    The question is, if I update the order_dt via the back end in T_ORDER, will it cause any issues that I don't know about?

     

    Cheers,

     

    Matt




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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
  • Former Member
    Former Member $organization

    Good day, Matt

     

    We’re relatively new to Tessitura, making the final switch this past July.

    Then, in July, we completed a messy rollover process.

    Because of the messy process, we had many orders with a “bad” order date (and bad data in other fields).

     

    Using SQL, I updated *many* fields in T_ORDER to clean things up.

    Unsure how others will respond, but we haven’t seen any negative effects.

    It certainly resolved problems with T-Stats.  Mgmt is finally seeing something useful.

     

    Let me know if I can help, and …

     

    Good Luck

     

    Wendell Baskin

    Bass Hall – Fort Worth

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matthew Hodge
    Sent: Thursday, August 29, 2013 02:23
    To: Wendell Baskin
    Subject: [Tessitura Technical Forum] Will Tessitura blow up if I change an order_dt with SQL?

     

    Quick question - my box office has asked me to change an order_dt on a particular order for a customer, but the order has been saved, so it can't be modified any further from within Tessitura.

    The question is, if I update the order_dt via the back end in T_ORDER, will it cause any issues that I don't know about?

     

    Cheers,

     

    Matt




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