data
data copied to clipboard
It's impossible to use case insensitive search via "where" statement
some="Abc"
where: { some: { contains: "abc", }, },
Actual result: no matches
I have the same problem, it would be great if we could do something like this:
where: {
name: {
contains: 'search text',
caseSensitive: false,
}
}
Alternatively, new case insensitive string operators would also do the trick. Something like ciContains, ciNotContains, ciEquals, ciNotEquals...