Activity Status Description

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

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

Weird. I just copied your code into my test environment and it ran successfully. Are there other elements in your output set that could be causing the issue instead?

Thanks everyone. I think Beth was right, that it was a problem somewhere else in my output set. But now I have developed a different problem.

The code I created makes one row for each status the person has ever put down times each event they have ever gone to. I know this is the exponential combinations problem but I can't figure out why I would be getting it since each event should be associated with the status number directly and so shouldn't the code I created just pull the correct status for that event?

Thanks so much for all your help so far!

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

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?

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!