Hey there,
I’m currently trying to figure out if the DatoAPI supports the AND-operator on filters?
In other GraphQL tutorials I see that the same way the OR-operator works, there should be an AND-operator: https://grandstack.io/docs/graphql-filtering/#logical-operators-and-or
But in reality the API tells me InputObject 'ShoeModelFilter' doesn't accept argument 'AND'.
In my use case I have a field on a record which specifies a certain “category”, let’s say the available categories are: Coming Soon, In Stock, Countdown, Sold Out…
I want to query all records, which are not Coming Soon and not In Stock.
So every record that would have Countdown set, or Sold Out set etc.
If I use the OR-operator, obv. this won’t work since a record with Coming Soon would match the neq: "In Stock" filter and vice versa.
The filter I tried to use is:
AND: [
{shoeShowInReleases: {eq: "true"}},
{releaseStatus: {neq: "Coming Soon"}},
{releaseStatus: {neq: "Countdown"}}
]
Does the API really not support the AND-operator? And is there a good reason for it? I think this is quite a needed feature for an API.
Thanks for a heads up into the right direction.
Stay Safe!