Cannot sort search results within nested objects in Elasticsearch 7

Question

I want to sort objects in ascending order but the sort doesn't work.

Here is a sort query below.

"sort":[
{
    "category.position": {
        "order":"asc",
        "mode":"min",
        "nested": {
            "path": "category",
            "filter": {
                "term": {"category_category_id":42} }
        }
    }
}]

And here are the objects below.

"name": "Yeti",
"category": [
        {
        "category_id": 42,
        "name": "Raamiga",
        "position": 3
        },
    ],
"name": "Venus",
"category": [
        {
        "category_id": 42,
        "name": "Raamiga",
        "position": 4
        }
    ],

Please, help! Many thanks in advance!

antoniog · Accepted Answer · 2022-07-20 18:09:35Z

1

Solved. There was a typo… Must be "category.category_id" indtead of "category_category_id".

answered Jul 20, 2022 at 18:09

antoniog

112 bronze badges

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

Collectives™ on Stack Overflow

Cannot sort search results within nested objects in Elasticsearch 7

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