CODEWITHSUNDEEP
angulargraphqlwhere-clauseapollostrapi
Muhammad Ali Toshpulatov
Muhammad Ali Toshpulatov

Reputation: 101

How to query with multiple 'and' conditions in where clause in Strapi, GraphQL?

Now I am trying to query with multiple _and inside where in Strapi GraphQL playground. The query I am using is:

 {
  clients(
    where: {
      _and: [{ name: { _contains: "a" } }, { endDate: { _gte: "2017-12-31" } }]
    }
  ) {
    id
    name
    endDate
    reasonForEnding
  }
}

But getting an error with says the following:

 "Error: Your filters contain a field '_and' that doesn't appear on your model definition nor it's relations".

How to do properly query with multiple _and conditions where clause in Strapi with GraphQL

Upvotes: 6

Views: 9741

Answers (2)

Kubra Altun
Kubra Altun

Reputation: 405

Just adding to @Mohammad Sadeq Sirjani's answer; instead of and, it is _and. So in summary it would be:

clients(
  where: {
    _and: [{ name: { contains: "a" } }, 
           { endDate: { gte: "2017-12-31" } }]
         }
) {
    id
    name
    endDate
    reasonForEnding
  }

Upvotes: 2

Mohammad Sadeq Sirjani
Mohammad Sadeq Sirjani

Reputation: 650

clients(
  where: {
    and: [{ name: { contains: "a" } }, { endDate: { gte: "2017-12-31" } }]
  }
) {
    id
    name
    endDate
    reasonForEnding
  }

This is the answer

Upvotes: 3

Related Questions