I use the Rule-based Row Filter to select rows from the following table:
I to filter rows where
taxid_source matches one of a list of values:
$taxid_source$ = "9606" => TRUE
$taxid_source$ = "10090" => TRUE`
This works well but the filter values are hardcoded.
I have the filter values in a table. What would be the best way to create dynamic rules when the number of filter values is unknown?
Since your goal is just to check whether the “taxid_source” is equal to a list of possible values, you could use a -Reference Row Filter as follow:
where the 2nd table contains all the “taxid_source” values you need to filter in.
Hope this helps.
Thanks @aworker, that works and is even faster than the Rule-based filter.
@mpreusse thanks for your feedback and for validating the solution. Glad to read that it works for you and it is even faster !
If you join a second table using an inner join it should work too I suppose
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.