Hello,
Has anyone inserted content types and values to a group of performances using SQL?
I'd love to insert the same content type with the same value to a group of shows (either by Season ID or Title ID) but Season Maintenance in the client doesn't cover this area, so thought maybe someone out there has used SQL to do it?
Beau.
Ohh yes please – that would be wonderful! J
From: Amanda Freeman [mailto:bounce-amandafreeman5080@tessituranetwork.com] Sent: Friday, 6 January 2012 09:22To: Beau VigushinSubject: Re: [Tessitura Technical Forum] Inserting Content Fields in bulk
Yup. I do it all the time. Do you need an example?
From: Beau Vigushin <bounce-beauvigushin8188@tessituranetwork.com>Sent: 1/5/2012 4:19:08 PM
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!
So for your example for every show in a certain season you might want to do this:
INSERT INTO tx_inv_content( inv_no, content_type, value)
Select p.prod_season_no, 1, 'yay content' --replace with your real content type and content value
from t_prod_season p
where p.season= 40--replace with whatever season
or if you needed the content on the individual perfs this:
Select p.perf_no, 1, 'yay content' --replace with your real content type and content value
from t_perf p
where p.season=40 --replace with whatever season
Thank you Amanda! I owe you a drink @TLCC2012 :)