SQL Help

I was going to go through a lot of trial and error but one of you must have this sitting somewhere.  I'd like to insert attributes on mass, I'm assuming to the tx_cust_keyword, based on a constituency. Any SQL you'd like to share?

 

Chris

Parents
  • There is a shared report on TASK that can help you, which I believe is called Add Attributes to List.  In v9.0 there is a new utility called “Manage Attributes” that will allow you insert, delete, or update attributes to constituents on a selected list.

    ______________________________________

    Ryan Creps

    Network Developer |Tessitura Network, Inc

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Chris Howarth
    Sent: Wednesday, May 13, 2009 3:52 PM
    To: Ryan Creps
    Subject: [Tessitura Ticketing Forum] SQL Help

     

    I was going to go through a lot of trial and error but one of you must have this sitting somewhere.  I'd like to insert attributes on mass, I'm assuming to the tx_cust_keyword, based on a constituency. Any SQL you'd like to share?

     

    Chris




    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!

    No virus found in this incoming message.
    Checked by AVG - www.avg.com
    Version: 8.5.325 / Virus Database: 270.12.24/2108 - Release Date: 05/13/09 07:04:00

Reply
  • There is a shared report on TASK that can help you, which I believe is called Add Attributes to List.  In v9.0 there is a new utility called “Manage Attributes” that will allow you insert, delete, or update attributes to constituents on a selected list.

    ______________________________________

    Ryan Creps

    Network Developer |Tessitura Network, Inc

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Chris Howarth
    Sent: Wednesday, May 13, 2009 3:52 PM
    To: Ryan Creps
    Subject: [Tessitura Ticketing Forum] SQL Help

     

    I was going to go through a lot of trial and error but one of you must have this sitting somewhere.  I'd like to insert attributes on mass, I'm assuming to the tx_cust_keyword, based on a constituency. Any SQL you'd like to share?

     

    Chris




    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!

    No virus found in this incoming message.
    Checked by AVG - www.avg.com
    Version: 8.5.325 / Virus Database: 270.12.24/2108 - Release Date: 05/13/09 07:04:00

Children
No Data