Multi filters with multiple comparators

[AnnekimBanchereau]

Hello,
thank you for your very useful library.
Unfortunately, we have some issues with multi filters.

orders?filter.families=$ilike:REMOV&filter.families=$or:$ilike:IMPLANT&filter.dentistName=$ilike:b

The generated request is :

WHERE (UPPER(`product`.`families`) LIKE UPPER(?) OR UPPER(`product`.`families`) LIKE UPPER(?) AND UPPER(`product`.`dentistName`) LIKE UPPER(?))

In this case, the last filter dentistName is not working, because it is located between the brackets.

The documentation explains :

Note: The first comparator on the first filter is ignored because the filters are grouped by the column name and chained with an $and to other filters.

...&filter.id=5&filter.id=$or:7&filter.name=Milo&...

is resolved to:

WHERE ... AND (id = 5 OR id = 7) AND name = 'Milo' AND ...

The expected generated request should be:

WHERE (UPPER(`product`.`families`) LIKE UPPER(?) OR UPPER(`product`.`families`) LIKE UPPER(?)) AND UPPER(`product`.`dentistName`) LIKE UPPER(?)

Thank you for your help :)

[ppetzold]

seems like a bug. multi filters coverage is minimal. your expected where expression is definitely the intended version.

[natoszme]

Hy there! Any updates on this? Thanks

[linsolas]

Hello all,

I just encountered the same issue as you. However, it seems it is resolved by adding the $or: even for the first filter value (despite what the document says), so something like this:

- orders?filter.families=$ilike:REMOV&filter.families=$or:$ilike:IMPLANT&filter.dentistName=$ilike:b
+ orders?filter.families=$eq:$ilike:REMOV&filter.families=$or:$ilike:IMPLANT&filter.dentistName=$ilike:b