I using the rule based row filter and I write the following:
($col_1$ LIKE "ABC*" OR $col_1$ LIKE "CDE*") AND ($col_2$ LIKE "SAD*" OR $col_2$ LIKE "ART*" )=>TRUE
And it doesn't give me what I need. How I can write the OR AND statement combination to get where I want?
Could you please explain what it is exactly that you need?
Yes, maybe it wasn't so clear.
Is there a way to write properly a combination of AND & OR statement in rule based row filter.
For example, IF (COLUMN_X=A OR COLUMN_X=B) AND (COLUMN_Y=C OR COLUMN_Y=D) => TRUE
I tired couple of times to play around with this kind of statement but it seems AND does not work with nested OR.
am I right?
The way you formulated the statement, it should produce exactly what you want. Is it possible that you are missing something in your LIKE statements? I.e, do you really only want to match the beginning of a string, or also sequences somewhere else in the string?