This seems like it should be an easy fix but I'm not sure how to wrap my head around it. Is there a way to update the Customer Prefix query element so that it will disply the description of the Prefix and not the ID number? Customer Prefix is pulled from one of those special tables and I'm not sure if I can modify the element. And I'm not sure how diffcult a new element would be to create.
Thanks in advance for suggestions.
Elizabeth Carlock
Thank you, I will try that and see what happens. Knew it should be easy.
Director of Ticketing Services
The Granada Theatre
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Paul Kappel Sent: Friday, February 22, 2013 2:18 PM To: Elizabeth Carlock Subject: Re: [Tessitura Technical Forum] Get Prefix description in an output set instead of the ID number
Hey Elizabeth,
It should be pretty easy to set up a new row in TR_QUERY_ELEMENT, we use:
Data Select: !.prefix_desc Data From: (select c.customer_no, p.description as prefix_desc from t_customer c join tr_prefix p on c.prefix=p.id) Data Where: blank Single Row: Check
From: Elizabeth Carlock <bounce-elizabethcarlock8778@tessituranetwork.com> Sent: 2/22/2013 1:15:13 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!