Tablepane filters and joins
I have a tablepane which uses Sql to get his data:
As you look at the ''Business" column i have to type a number (key Value) to get the [Fashion Retail] value.
How do I have to modify the Built WHERE clause in order to filter on name /description of the Join Fields instead of the key value? I would like to filter on name/description rather than a key value. Some sample code is appreciated! Thanks in advance.
Discussion (1)0
Comments
Just add another IF condition and replace all "Country" by " Relation"
If ($g(pInfo:filters("Relation"))'="") {
Set tWHERE = tWHERE _ $S(tWHERE="":"",1:" AND ") _ "Relation %STARTSWITH '" _ pInfo:filters("Relation") _ "'"
}