I've been trying to add a field (from a view I created) to T_KEYWORD so that it may be used as a criterion in List Manager. So far so good it would seem. However, when I choose it from the left pane and drag it over to the right, I am only allowed to use "In" instead of the more logical "Like", or even "=" since it is a string and not an integer. The really odd thing is that under the value column, the drop down shows the appropriate pre-designated values as set up in T_KEYWORD through System Tables. But, when you choose one and look in the bottom pane by clicking "Display Query", you get the following string:
AND f.perf_code in ('if(inactive=''Y'', RGB(100,100,100),RGB(0,0,0))')
This appears to be the code that tells Tessitura how to display inactive values. The question is why on Earth would it do that rather than give me a syntax error or something?
The ultimate question of course is: What am I doing wrong?
Any ideas? Thank you in advance, Tessiturians.
BONUS ACTIVE TRIVIA: The only part of the human body that has no blood supply is the cornea in the eye. It takes in oxygen directly from the air.
The "in" operator makes sense if you have defined pre-set values when you set up things in t_keyword (I'm assuming the values are set up in t_kwcoded_values). If you have pre-set values you don't need "like" or = since you are simply choosing from a pre-determined list.
If you get rid of the values in t_kwcoded_values, I would think you would see different results.
If the value is selected from a dropdown you can only use the In, Has, Not In, and Does Not Have operators.
I think the best thing to do to figure out what is going on with your values is to open a help ticket.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com