How to use OR / AND in graphql query filter or make a case insensitive filter?

Question

Just like the post ask I need to be able to search with 3 possible scenarios. I need to have all uppercase, or lowercase, or normal casing.

If that is not possible is there a way to do a case insensitive filter instead?

  allMarkdownRemark(filter: { brand: { eq: $normalBrand } }) { //==> Need more here
        edges {
            node {
                webImages {
                    url
                }
            }
        }
    }

I found some people doing this:

filter: { OR: [
  {brand: { eq: $normalBrand }}, 
  {brand: { eq: $normalBrand2 }}, 
  {brand: { eq: $normalBrand3 }}
]}

But it does not work for me

This might be relevant: github.com/graphql-compose/graphql-compose-mongoose/issues/93 — Apr 19, 2019 at 21:42

ThymineThymine 8,8552 gold badges35 silver badges47 bronze badges · Accepted Answer · 2018-07-25 19:52:58Z

Currently there is not anything built-in to graphql itself that uses case insenstive search, its completely based on whatever library the graphql server is running and if that chooses to add support for that. If you can modify the graphql query code, you can add that in yourself in some fashion, or request whoever is hosting/building that to add in that feature somehow.

Regarding OR, I doubt I could say it better than https://github.com/graphql/graphql-js/issues/585#issuecomment-262402544

GraphQL doesn’t have support for AND/OR operators for exactly the reason you mentioned at the top of your issue: it does not map to any kind of storage. I think to properly understand why it does not have these requires a shift in mental models. We think of GraphQL as more similar to RPC languages than database languages.

To help understand the mental model shift, it’s useful to think about fields and arguments like function calls in programming languages. So suppose we ask a similar question of javascript: Why can’t you type: getCaseByStatus("open" OR "closed")? The answer, I would assume, is because JavaScript does not know what OR means in this context. Should the values "open" and "closed" be combined in some way to produce another value? Should the execution of the function getCaseByStatus change in some way? JavaScript can’t be sure – because the concept of field-based filtering is not part of JavaScript’s semantics.
…

Its not a query language if you cant ask it things.

– StingyJack

Dec 18, 2020 at 6:16 — Dec 18, 2020 at 6:16

2 revs Sam · Accepted Answer · 2020-06-10 21:08:55Z

Does regex work? Something like

  allMarkdownRemark(filter: { brand: { 
     regex: "/($normalBrand)|($normalBrand2)|($normalBrand3)/" 
  } }) { 
        edges {
            node {
                webImages {
                    url
                }
            }
        }
    }

Ahmed Ashour 5,20210 gold badges36 silver badges57 bronze badges · Accepted Answer · 2023-11-10 07:29:08Z

0

Try to filter with a lower case or:

filter: { or: [{brand: { eq: $normalBrand }}, {brand: { eq: $normalBrand2 }},{brand: { eq: $normalBrand3 }}]}

edited 1 hour ago

Ahmed Ashour

5,20210 gold badges36 silver badges57 bronze badges

answered May 6, 2021 at 3:53

Arif Faisal

1

Ahmed Ashour 5,20210 gold badges36 silver badges57 bronze badges · Accepted Answer · 2023-11-10 07:29:21Z

0

GraphQL doesn’t directly support case insensitive, but regex sure does. This worked for me:

{brand: {regexp: "/$normalBrand/i"}}

edited 1 hour ago

Ahmed Ashour

5,20210 gold badges36 silver badges57 bronze badges

answered Sep 19, 2022 at 13:46

Derek Ball

751 silver badge6 bronze badges

How to use OR / AND in graphql query filter or make a case insensitive filter?