Move Perf to Different Title

Hi all!

I built a few performances under the wrong Title in Production Elements. I really don't want to build them again under the correct one - they were kind of a pain the first time!

I noticed there is a prod_season_no value in T_PERF. Does anyone know if it will break things if I simply update that with the prod_season_no that I want? Or is there a better way to move perfs?

Thanks!

Parents
  • Beth,

     

    I did it a couple of years ago exactly like you described , had no issues:

     

    update t_perf set prod_season_no = 1941

    where perf_no in (2057,2058,2059)

     

     

    Sabina

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Hawryluk
    Sent: Friday, February 22, 2013 12:14 PM
    To: Sabina Spilkin
    Subject: [Tessitura Technical Forum] Move Perf to Different Title

     

    Hi all!

    I built a few performances under the wrong Title in Production Elements. I really don't want to build them again under the correct one - they were kind of a pain the first time!

    I noticed there is a prod_season_no value in T_PERF. Does anyone know if it will break things if I simply update that with the prod_season_no that I want? Or is there a better way to move perfs?

    Thanks!




    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
  • Beth,

     

    I did it a couple of years ago exactly like you described , had no issues:

     

    update t_perf set prod_season_no = 1941

    where perf_no in (2057,2058,2059)

     

     

    Sabina

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Hawryluk
    Sent: Friday, February 22, 2013 12:14 PM
    To: Sabina Spilkin
    Subject: [Tessitura Technical Forum] Move Perf to Different Title

     

    Hi all!

    I built a few performances under the wrong Title in Production Elements. I really don't want to build them again under the correct one - they were kind of a pain the first time!

    I noticed there is a prod_season_no value in T_PERF. Does anyone know if it will break things if I simply update that with the prod_season_no that I want? Or is there a better way to move perfs?

    Thanks!




    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