Filter on nested object field and nested array of objects field.

[gmourier]

As we do not support filtering on nested objects fields, it forces users to denormalize the data.

e.g.

{
    "ISBN": "979-8455737053",
    "title": "Twenty Thousand Leagues Under the Seas: (Classics Illustrated and Annotated)",
    "price": 12.65,
    "author": {
        "name": "Jules Verne",
        "shortBio": "Jules Verne, born on February 8, 1828 in Nantes and died on March 24, 1905 in Amiens, is a French writer, whose work is devoted to novels of adventure and anticipation."
    }
}

needs to be transformed to

{
    "ISBN": "979-8455737053",
    "title": "Twenty Thousand Leagues Under the Seas: (Classics Illustrated and Annotated)",
    "price": 12.65,
    "author_name": "Jules Verne",
    "author_shortBio": "Jules Verne, born on February 8, 1828 in Nantes and died on March 24, 1905 in Amiens, is a French writer, whose work is devoted to novels of adventure and anticipation."
}

It would be interesting to express a filter on a nested field.

{
    "filter": "author.name = 'Jules Verne'"
}

We could go further and also allow to filter on a field of objects contained in an array.

e.g. Having books containing multiple co-authors.

[
        {
            "ISBN": "979-8455737053",
            "title": "Twenty Thousand Leagues Under the Seas: (Classics Illustrated and Annotated)",
            "price": 12.65,
            "co-authors": [
                {
                    "name": "Jules Verne",
                    "shortBio": "Jules Verne, born on February 8, 1828 in Nantes and died on March 24, 1905 in Amiens, is a French writer, whose work is devoted to novels of adventure and anticipation."
                },
                {
                    "name": "Secret Jules Verne's sidekick",
                    "shortBio": null
                }
            ]
        }
]

e.g. A filter may be expressed this way

{
    "filter": "co-authors.name = 'Jules Verne'"
}

[fatihyildizhan]

This feature will be amazing one 👀

[jkdoshi]

YES! This would be great. I just added a similar comment here - meilisearch/meilisearch#2211 (comment)

[gmourier]

Hey @jkdoshi 👋

We haven't included support for array index notation for this iteration, but it's potentially something we could add in the future, depending on the needs we gather.

I invite you to create a dedicated discussion giving us more information on this need. Thank you 🙏

[gmourier]

Hey 👋

Guess what? It's now a reality! ✨

You can now use the dot-notation . to specify the use of a nested field in the settings definition or at search time.

e.g. "filter": "company.name = 'Meilisearch'"

Our goal was to remove the hassle you encountered by being forced to flatten the nested fields at the root of your document on your end to get the full power of Meilisearch.

Don't hesitate to let us know what can be improved by creating a new discussion.

Thank you for being part of the Meilisearch community.