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?
Jacob,
I did something similar recently, and have just tested using your code and had no issues with it at all.
I would maybe trying removing everything from the Data Select and Data where columns and re typing in case there is an errant space in there.
Caryl