Having trouble with "_and" & "_or" queries

[baronyoung]

Hi everyone. I'm getting unexpected behavior from filtering queries I'm making using the _and & _or operators. Take the following query:

query MyQuery {
audits(where: {_and: {
treatment_date: {_gt: "12/2/2020", _lt: "12/18/2020"},
_or: {
technician: {_eq: "Pauline O'Gormally"},
status: {_eq: "Cancelled"}
}
}}) {
technician
treatment_date
status
}
}

As written, I would expect this query to return all records with...

• {treatment_date}s between 12/2/2020 and 12/18/2020
• AND
  • EITHER
    • {technician} of "Pauline O'Gormally"
    • OR
    • {status} of "Cancelled"

I have the following record that should be returned if this works correctly:

{
"data": {
"audits": [
{
"technician": "Pauline O'Gormally",
"treatment_date": "2020-12-15",
"status": "Complete"
}
]
}
}

However, I get an empty set. If I remove the {status} filter I do get the record back. It seems it's doing an AND instead of an OR within the last piece. What am I doing wrong? Thanks in advance for any help.

[baronyoung]

I found my problem. _or filters must be surrounded with square brackets as an array. These are not inserted on the GraphiQL interface which is what caused my confusion - they must be added manually.