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

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!

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!