Using multiple filters operators on same column are not supported, except for the following cases:
-
columnname eq value1 or columnname eq value2
-
columnname ne value1 and columnname ne value2
-
columnname eq value1 or columnname eq value2 or columnname eq value3 or columnname eq value4…
-
columnname ne value1 and columnname ne value2 and columnname ne value3 and columnname ne value4…
-
columnname gt value1 and columnname lt value2 (where value1<value2)
-
columnname lt value1 and columnname gt value2 (where value1>value2)
On different columns, only AND operators are supported.
For example,
columname1 eq value1 and columnname2 eq value2 and columnname3 eq value3......
Invalid Combinations of using filter operators
-
columname1 eq value1 and columnname2 eq value2 or columnname3 eq value3
-
columname1 eq value1 or columnname2 eq value2 and columnname3 eq value3