Get Prefix description in an output set instead of the ID number

Hi Elizabeth

Rather than edit the existing entry it’s best if you add a new row to TR_QUERY_ELEMENT for the prefix ‘description’.

The following setup should get you what you’re after:

Description:        Customer Prefix Description (or any other name that suits you)

Category:            Customer

Data Select:        !.prefix_desc

Data From:          (select p.description as prefix_desc, c.customer_no from t_customer c join TR_PREFIX p on p.id = c.prefix)

Hope that helps

Regards

Peter

+ Peter Nelson

+ Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Elizabeth Carlock
Sent: Friday, 22 February 2013 2:21 PM
To: Peter Nelson
Subject: [Tessitura Technical Forum] Get Prefix description in an output set instead of the ID number

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

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!

Yes Elizabeth there is and I think it’s in the Output Set Builder cookbook. If not, here’s what I have:

Description:        Customer Prefix Full

Data_select:       !.prefix_desc

Data_from:         (select a.customer_no, a.prefix, b.description as 'prefix_desc' from t_customer a join tr_prefix b on a.prefix = b.id)

Data_where:     blank

Single_row:        checked

You might want to overtype the single quotes after you have pasted the data_from into Tess. Sometimes Outlook and Word turn them into non SQL friendly versions of the single quotes.

Cheers

Sandra

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Elizabeth Carlock
Sent: Saturday, 23 February 2013 7:28 AM
To: Sandra Ashby
Subject: [Tessitura Technical Forum] Get Prefix description in an output set instead of the ID number

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

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!

Thank you, I will try that and see what happens.  Knew it should be easy.

Elizabeth Carlock

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

Thank you.  I knew it should be easy.  I will try this and see what happens.