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?
Try this:
select c.customer_no, status_desc = p.description, c.status from VS_SPECIAL_ACTIVITY c join TR_SPECIAL_ACTIVITY_STATUS p on p.id = c.status