How to sort elasticsearch by multiple fields while comparing the values of those fields to each other?

Question

Let's say I have three objects

[
    {
        'name' : 'Apple',
        'popularityFoo': 100,
        'popularityBar': 80,
        'popularity': 40,
    },
    {
        'name' : 'Banana',
        'popularityFoo': 50,
        'popularityBar': 90,
        'popularity': 50,
    },
    {
        'name' : 'Cherry',
        'popularityFoo': 60,
        'popularityBar': 60,
        'popularity': 60,
    }  
];

My default sorting is by popularity, returning Cherry (60), Banana (50), Apple (40) If a user has a preferred category it will sort first by that category popularity index and then fall back to popularity. So if my favorite category is Foo it returns Apple (100), Cherry (60), Banana (50) and for category Bar the search returns Banana (90), Apple (80), Cherry (60)

Now my question: If my user likes both Foo and Bar how can I compare the different popularity values with each other when sorting so I can get the result Apple (100), Banana (90), Cherry (60)? Am I indexing wrong? Should I approach this differently?

I have 20 categories and my users have 1-3 favorite categories.

Mohammad Akbari · Accepted Answer · 2018-02-08 04:14:50Z

1

Use script for conditional sorting as following:

{
    "sort" : {
        "_script" : {
            "type" : "number",
            "script" : {
                "lang": "painless",
                "inline": "doc['popularityFoo'].value > doc['popularityBar'].value ? doc['popularityFoo'].value : doc['popularityBar'].value"
            },
            "order" : "desc"
        }
    }
}

answered Feb 8, 2018 at 4:14

Mohammad Akbari

4,8146 gold badges52 silver badges80 bronze badges

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

1 Comment

Moak Over a year ago

Thanks, this helped me find the answer!

Moak · Accepted Answer · 2018-02-13 04:46:41Z

0

Thanks to Mohammad's answer for the hint, the way I solved this is using Math.max(double a, double b) nesting the function for each additional category.

"sort": [
    {
      "_script": {
        "script": "Math.max(doc['popularityFoo'].value, Math.max(doc['popularityBar'].value, doc['popularityBaz'].value))",
        "type": "number",
        "order": "desc"
      }
    }
]

answered Feb 13, 2018 at 4:46

Moak

12.9k27 gold badges117 silver badges168 bronze badges

Collectives™ on Stack Overflow

How to sort elasticsearch by multiple fields while comparing the values of those fields to each other?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related