I want to use lvs_tkt_hist to display the zone in list builder. When I use t_zone as the RefCol, zone_no as the IDCol, and Description as the description column, I am getting duplicate values in the drop down (many zones are tied to different zone maps). Do I need to create a view to select distinct descriptions from t_zone? Or create a view from lvs_tkt_hist and add the zone description to that? Or...is there a way I can sneak Distinct into List Builder?
It's a little different, but if memory serves I was doing a similar thing with report setup (doing something clever to restrict or reformat the menu text options) and it stopped working in V11. I'd go ahead and make the view: they're cheap and will make your configurations easier to maintain.
--Gawain
Which is to say I'd probably do the first thing (view on T_ZONE).
Thanks Gawain! I’ll do that.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers Sent: Thursday, August 01, 2013 3:22 PM To: Gloria Ormsby Subject: Re: [Tessitura Technical Forum] Zone in List Builder
From: Gawain Lavers <bounce-gawainlavers9512@tessituranetwork.com> Sent: 8/1/2013 1:52:32 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!