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!

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!

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!

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!