Case insensitive search with multiple fields

[ravargash]

Hello again!

I'm trying to make a "smart search" where, using a single term in a single query, replies with all the similar results. Let's suppose we have this schema:

And I want to get results based on its name, brand or services. The query would be something like this:

It does work! Cool and all, however, this search is not case insensitive, so its application is a bit janky.

How should I approach this?

Regards!

[adas98012]

You can use "_ilike" operator instead of "_similar":

Reference

Here is a sample query and response:

query MyQuery2 {
  Album(where: {Title: {_ilike: "%For%"}}) {
    ArtistId
    Title
  }
}

"data": {
    "Album": [
      {
        "ArtistId": 1,
        "Title": "For Those About To Rock We Salute You"
      },
      {
        "ArtistId": 82,
        "Title": "King For A Day Fool For A Lifetime"
      },
      {
        "ArtistId": 88,
        "Title": "Appetite for Destruction"
      },