jo-ka
Member
Hello, Using J!3.8.
I'm trying to use this filter on a Dbjoin element:
CASE WHEN {$my->groups} LIKE '%20%' THEN license = '5015' ELSE license<> '»»' END
but it fails with 1064 error.
If I use:
CASE WHEN {$my->id} = '1920' THEN license = '5015' ELSE license <> '»»' END
It works OK.
I would expected that {$my->groups} works correctly, as per this wiki information.
http://fabrikar.com/forums/index.php?wiki/placeholders/#my-gt-xxx
Am I doing something wrong?
Thanks in advance
I'm trying to use this filter on a Dbjoin element:
CASE WHEN {$my->groups} LIKE '%20%' THEN license = '5015' ELSE license<> '»»' END
but it fails with 1064 error.
If I use:
CASE WHEN {$my->id} = '1920' THEN license = '5015' ELSE license <> '»»' END
It works OK.
I would expected that {$my->groups} works correctly, as per this wiki information.
http://fabrikar.com/forums/index.php?wiki/placeholders/#my-gt-xxx
Am I doing something wrong?
Thanks in advance