Rule Based row filter with variable and wildcards how too?

Rule Based row filter with variable and wildcards how too?

$some_data$ LIKE " * green * " => TRUE (works fine)

But want to use Variable at the moment
$some_data$ LIKE $${SRow0}$$ => TRUE
but were can i add * * so take in to account its wildcard (in side of Rule Based row filter )

or is it only way to do it is downstream with the variable is in data table * green *

Hi there!

Don’t think it is possible to use flow variable with wildcards (or manipulate in any way with flow variable) in Rule based nodes because of the flow variable syntax in those nodes.

There are couple of workarounds and I would suggest to use String Manipulation (Variable) node where you would transform green to * green * and then use it in Rule Based Row Filter node.

Br,
Ivan

1 Like