sorting nested documents in elastic search

Question

I have a nested field in elastic search document with 2 fields:

blog = Nested(
    properties={
        'id': Integer(),
        'rating': Integer()
    }
)

An ES document has a list of blogs: blog1, blog2 etc.

I want all the documents with blob.id = x and sorted on the rating field corresponding to that blob. Is it feasible to perform this with an elastic search query without a ranking script. Please advice.

Val · Accepted Answer · 2016-08-16 05:21:13Z

1

Something like this should do what you need:

{
  "query": {
    "nested": {
      "path": "blog",
      "query": {
        "term": {
          "blog.id": 123
        }
      }
    }
  },
  "sort": [
    {
      "blog.rating": {
        "order": "asc",
        "nested_path": "blog",
        "nested_filter": {
          "term": {
            "blog.id": 123
          }
        }
      }
    }
  ]
}

answered Aug 16, 2016 at 5:21

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

sorting nested documents in elastic search

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