Howdy Folks,
We have noticed that when we run an output set the data in phone_1 shows up under the phone_2 column and vice versus, however when you look at the constitutents record the data is where it should be. I went into t_keyword to verify where the data is pulling from but those values are not in that table, where else shall I look to correct this issue?
Naomi
Hi Suzanne
The simplest way to get phone1, phone2 and fax (ie types 1,2 and 3) in your output is to add a bit of code to LP_GET_PHONES where you assign the variables @day_phone, @eve_phone and @fax_phone to the phone type you want.
AP_GET_PHONES calls this procedure each time it’s run so you get the phone details you want.
Hope that helps.
Sandra
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Suzanne Bridger Sent: Wednesday, 14 January 2015 4:22 AM To: Sandra Ashby Subject: Re: [Tessitura Technical Forum] Switching Phone1 and Phone2 in the output set builder
Hi
I've only just had this brought to my attention today by our box office - they've been working round it for I don't know how long.
Is this something that has, or will be, addressed properly? The coding talks about day and evening numbers when we're all expecting Phone1 or 2 irrespective of what time of day.
From: Naomi Williams <bounce-naomiwilliams9587@tessituranetwork.com> Sent: 3/25/2010 12:27:01 PM
Thanks all for the help, I went back into those stored procedures and they were wrong for our setup. I adjusted them as needed.
Brian, thank you for the script that was most helpful!
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!
That's what I don't understand - why do we have to start dealing with code that is looking at the day and evening flags? Query builder sets that are requesting phone1 are not getting phone1. This is logically wrong.
We don't use the D/E flags in a structured way so 85% of phone records have no meaningful value.