I have a doubt when working with rules, using a rule-based row filter node, where I want to consider intervals (or maybe ranges) for filtering. For instance, consider I have one column named ID and I just want to retrieve the ids that start with A* to C*.
What I’ve been doing is use some filters like the following:
$id$ LIKE “A*” OR $id$ LIKE “B*” OR $id$ LIKE “C*” => TRUE
I want to optimize this, to avoid such huge rules like the one if I consider a larger interval, such as A to G, for instance.
I just want to consider number intervals, as well, even if it requires to convert the values to int.
Here is an example of some data read from a table creator.
[Interval rule based row filter.knwf|attachment]
(upload://pmfyAvOSjuFlU83rmmBI3MsmCZJ.knwf) (6.7 KB)
Thanks in advance!