Elasticsearch custom sorting

Question

I'm using elasticsearch 7.7 and I have product documents which are like following :

[
     {"id": 1, "title": "product 1", "status": "available"},
     {"id": 2, "title": "product 2", "status": "will_be_available_soon"},
     {"id": 3, "title": "product 3", "status": "not_available"},
     {"id": 4, "title": "product 4", "status": "never_will_be_available_again"},
]

In my search queries I want to sort my products in a way that first I see available products, then I want to see will_be_available_soon products and after that not_available and of course at last never_will_be_available_again. and for products with the same status I want to sort based on their matching score.

@Gibbs Yes, it is. but It would be great if I had both options :D — Majid Abdolhosseini, Jun 18 '20 at 16:00
is that ok for you to change the mapping? `scripting` is quicker way to achieve but it is not good at performance. — Gibbs, Jun 21 '20 at 10:37

score 0 · Answer 1 · answered Jun 18 '20 at 19:29

0

You can run a custom query script. Have a look on this discussion: https://discuss.elastic.co/t/sorting-or-ordering-by-specific-values/67244/2 Another option is the score but might be an issue in a future.

answered Jun 18 '20 at 19:29

Tiago Mateus

356
4
17

Elasticsearch custom sorting

1 Answers1