[Hasura Cloud - v2.0.0-cloud.6] OR queries not working in Hasura Cloud

[L-U-C-K-Y]

Hi all

I am trying to write an OR query that looks as follows:

query MyQuery {
  guest(where: {_or: {email_code_verified: {_eq: true}, phone_code_verified: {_eq: true}}}) {
    id
  }
}

I would like to get all records where either the email_code_verified or the phone_code_verified is true.

Here a look into the db:

I am getting an empty response:

{
  "data": {
    "guest": []
  }
}

In the Analyze I can see that there is an AND instead of an OR:

[L-U-C-K-Y]

The discord community helped me out, Iearned that it is not possible to create such an OR query with the Hasura UI.

Are there any plans to support OR in the UI?

Query:

query MyQuery {
  guest(where: {_or: [{email_code_verified: {_eq: true}}, { phone_code_verified: {_eq: true} }] }) {
    id
  }
}

[L-U-C-K-Y]

Closing as tracking: #4488 #3322 OneGraph/graphiql-explorer#32