Mask character in filter->Condition

VCL TMS VCL UI Pack
1

Hi,

I would like to know how to "mask" a character like & within the Condition of a filter.

eg:  my_filter->Condition= "!"My Text A & B" & !"Your Text C & D"";

Thanks in advance

   Wolfgang

2

I found a way to get rid of this problem for the moment, but that should NOT be the final solution.

I just replace all "special" characters that are used for controlling the filter functionality like (!=<>&;") and replace them with ? before adding the string to the filter condition.

3

Hi Wolfgang :-)

just set the condition to quotes. Like, condtion = ""C&A"";

4

And what about quotes within condition ?

5

Also prefix the quote with the escape char.