I am trying to use the Rule Engine node using LIKE and NOT together, but cannot get it to work. Any ideas most welcome. My best attempt which is not accepted is below;
$Col1$ LIKE "*Cats*" AND $Col1$ NOT LIKE "*Dogs*" => "There are Cats But No Dogs Here"
This should work:
$Col1$ LIKE "*Cats*" AND NOT $Col1$ LIKE "*Dogs*" => "There are Cats But No Dogs Here"
I am afraid the NOT LIKE form is not supported by the nodes. (In case Col1 is boolean, you might need to add parentheses around the second LIKE expression.)
I thought I had tried every permutation but obviously not. This works like a charm.