Strapi filter: the "or" works as "and" in graphql

[ahmadjoya]

Bug report

• Node.js version: 16.15.1
• NPM version: 8.11.0
• Strapi version: 4.3.6
• Database: postgreSQL
• Operating system: Windows

Strapi filter: "or" works as "and" in graphql

hello community!
I am troubled while wanted to use complex filter using "or" for two fields.
here firstly I wanted filter by slug and setting an or operator that if the first filter is not working, than the second operator which is filter by itSlug should run.

Screenshots

this single filter is working

this complex query is not working

Code snippets

query category($locale: I18NLocaleCode, $slug: String) {
    categories(locale: $locale, filters: {slug: {eq: $slug}, or: [{itSlug: {eq: $slug}}]} ) {
      data {
        id
        attributes {
          categoryName
          slug
          description
          locale
        }
      }
    }
  }

[strapi-bot]

This issue has been mentioned on Strapi Community Forum. There might be relevant details there:

https://forum.strapi.io/t/strapi-filter-or-works-as-and/21782/3

[Convly]

Hi,

If you want to use or, you need to pass all the targeted clauses inside its array, putting the or next to another clause will create an and clause between the or components and the other ones.

Basically, what should work would be smth like: or: [{ slug: { eq: $slug } }, { itSlug: { eq: $slug } }]

[bolg55]

Closing as @Convly provided correct syntax. Not a bug.

[ahmadjoya]

[{ slug: { eq: $slug } }, { itSlug: { eq: $slug } }]

Thank you so much @Convly