Sorting on child occurrences Elasticsearch JAVA API

Question

{
  "skus" : [
    {
      "inv" : 426,
      "sub_category_id" : 677
    },
    {
      "inv" : 112,
      "sub_category_id" : 678
    },
    {
      "inv" : 0,
      "sub_category_id" : 611
    }
  ]
}

I have the document called 'product' with child object sku and i want to sort my product in a fashion that the if the number of sku with inv as 0 is more than 50% of total skus for the product should always go down and if it is not 50%, the order should not be affected.

Nikolay Papakha · Accepted Answer · 2015-12-02 09:41:34Z

1

The simpiest (and probably the most performance cost effective) way is to add computed field to your product object for a sorting purpose and compute it on each index/update product request.

answered Dec 2, 2015 at 9:41

Nikolay Papakha

18510 bronze badges

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

2 Comments

Val Over a year ago

Agreed! @naw, If you know in advance you'll need that information, you might as well index it. Otherwise, you'll have to resort to obscure scripting in order to achieve what you need.

naw Over a year ago

I was clear about indexing with a new score field but if this same thing can be achieved using SortingScriptBuilder? I was more interested in achieving this through a custom sort/group..

Collectives™ on Stack Overflow

Sorting on child occurrences Elasticsearch JAVA API

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related