data icon indicating copy to clipboard operation
data copied to clipboard

It's impossible to use case insensitive search via "where" statement

Open alexeygorbachevsky opened this issue 3 years ago • 1 comments

some="Abc"

where: { some: { contains: "abc", }, },

Actual result: no matches

alexeygorbachevsky avatar Dec 10 '22 15:12 alexeygorbachevsky

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...

sdelpuerto-intelygenz avatar Jun 27 '23 04:06 sdelpuerto-intelygenz