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.