Hi Everyone!
I am trying to create a new element for an output set that would return the Activity Status as a word instead of a number. I created code that I thought would map the status number from the special activity table to it's corresponding description in the special activity status table. It seemed like a pretty simple bit of coding and I came up with the following
Data Select: !.status_desc
Data From: (select c.customer_no, p.description as status_desc, c.status from VS_SPECIAL_ACTIVITY c join TR_SPECIAL_ACTIVITY_STATUS p on p.id = c.status)
But when I try to run the Output set it throws an error saying that I have an invalid column name 'description' but I know that description is a valid column in TR_SPECIAL_ACTIVITY_STATUS
Can anyone explain what I'm doing wrong?
Thanks Caryl, that makes a lot of sense. Do you have any idea how I'd go about it for something like this, where there are a lot of events one could theoretically chose from? From: Caryl Jones <bounce-caryljones3976@tessituranetwork.com> Sent: 4/16/2014 12:49:54 PM You would need to create a parameter to link directly to narrow it down to the specific event, so your users would have to add the parameter in output set to avoid the one to many link. Caryl 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!
Thanks Caryl, that makes a lot of sense. Do you have any idea how I'd go about it for something like this, where there are a lot of events one could theoretically chose from?
From: Caryl Jones <bounce-caryljones3976@tessituranetwork.com> Sent: 4/16/2014 12:49:54 PM
You would need to create a parameter to link directly to narrow it down to the specific event, so your users would have to add the parameter in output set to avoid the one to many link. Caryl