Filter not working if field name contains $ or %

Oblio · January 30, 2018, 4:42am

The help file indicates that this might be possible but I can't make it work.

e.g. If I have a user-defined field named $123 containing text "ok"

$123 HAS ok
$123 IS ok
$123 MATCHES .?
$123 PRESENT

Nothing works. Same for %123. Maybe it is not possible?

ohrenkino · January 30, 2018, 5:27am

For the $123 it should be
%$123%

Oblio · January 31, 2018, 2:26am

Thanks ohrenkino! That works.

How about %123 ?

ohrenkino · January 31, 2018, 6:25am

I think that this an illegal fieldname as the % is a reserved character.

Oblio · January 31, 2018, 6:47am

I think you must be right

Maybe Florian can update the help file.

Or make it work e.g. by escaping the % by using %%

So for %123 you use %%%123%

Please accept this feature request.