Elasticsearch condition on sorting in java

Question

For single field sorting I am using this code

searchSourceBuilder.sort(SortBuilders.fieldSort("count").order(SortOrder.DESC));

but now I need to add condition like this

searchSourceBuilder.sort(SortBuilders.fieldSort(count <= 0 ? "visitor":"visitor" * "count").order(SortOrder.DESC));

I am not getting any clue to do this. Is it possible at elasticsearch or I need to do it another way?

Val · Accepted Answer · 2020-10-13 06:07:38Z

2

What you need to use is SortBuilders.scriptSort() (script-based sorting), like this:

Script script = new Script( "doc.count.value <= 0 ? doc.visitor.value : doc.visitor.value * doc.count.value");
SortBuilders.scriptSort(script, ScriptSortType.NUMBER).order(SortOrder.DESC);

answered Oct 13, 2020 at 6:07

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch condition on sorting in java

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