jade
jade copied to clipboard
Create filter to search for an element in an array
The current implementation for contains
and not contains
does not covers the case where a property is an array. It performs a simple LIKE '%{value}%'
, which does not actually checks if the element exists, just that this word is in the serialized string in the database.
Example
Database value: Apples,Apple Macbook,Apple iPad
Element searching for: Apple
Expected result: No element found. Actual result: Matches the array.
I know there's no easy way to fix this and most likely it will be a BC, but I'm opening this issue as a reminder of a cool-to-have feature.