Directus Filtering multiple fields

Question

I'm trying to filter Directus CMS data set through URL parameters. This is a sample data set. I can successfully filter data set by single parameter.

{
   "data":[
      {
         "id": "1",
         "status": "published",
         "category": "Novel",
         "section": "Kids"
      },
      {
         "id": "2",
         "status": "published",
         "category": "Novel",
         "section": "Adults"
      }
   ]
}

/items/books?filter[category][_eq]=Novel

gives me exactly what I expected which is 1 & 2 data records. But I need to filter both "category" & "section" fields

/items/books?filter[category][_eq]=Novel&filter[section][_eq]=Adults

For above I receive an empty data set. Why is this getting failed ? Where do I need to fix? Appreciate your support in advance. Thanks!

Andrii Bodnar · Accepted Answer · 2023-01-08 11:19:04Z

1

Try the following query:

/items/books?filter={"_or":[{"category":{"_eq": "Novel"}},{"section":{"_eq":"Adults"}}]}

An expanded version of the filter:

"_or": [
    {
        "category": {
            "_eq": "Novel"
        }
    },
    {
        "section": {
            "_eq": "Adults"
        }
    }
]

Visit the official docs to read more about filtering rules and logical operators.

answered Jan 8, 2023 at 11:19

Andrii Bodnar

2,2562 gold badges20 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Directus Filtering multiple fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related