You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 :)
The text was updated successfully, but these errors were encountered:
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:
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 :
In this case, the last filter dentistName is not working, because it is located between the brackets.
The documentation explains :
The expected generated request should be:
Thank you for your help :)
The text was updated successfully, but these errors were encountered: