solr boost query with separate sort

Question

I want to demote all documents that have inv=0(possible values from 0 to 1000) to the end of the result set. i have got other sorting options like name desc also as part of the query.

For example below are my solr documents

Doc1 : name=apple , Inv=2
Doc2 : name=ball , Inv=1
Doc3 : name=cat , Inv=0
Doc4 : name=dog , Inv=0
Doc5 : name=fish , Inv=4
Doc6 : name=Goat , Inv=5

I want achieve below sorting ...here, i want to push all documents with inv=0 down to bottom and then apply "name asc" sorting.

Doc1
Doc2
Doc5
Doc6
Doc3
Doc4

my solr request is like

bq: "(: AND -inv:"0")^999.0" & defType: "edismax"

here 999 is the rank that i gave to demote results.

this boosting query works fine. it moves all documents with inv=0 down to the bottom.

But when i add &sort=name asc to the solr query, it prioritizes "sort" over bq..i am seeing below results with "name asc".

Doc1 : name=apple , Inv=2
Doc2 : name=ball , Inv=1
Doc3 : name=cat , Inv=0
Doc4 : name=dog , Inv=0
Doc5 : name=fish , Inv=4
Doc6 : name=Goat , Inv=5

can anyone please help me out. ?

Alexandre Rafalovitch Alexandre Rafalovitch · Accepted Answer · 2016-11-09T03:26:42

Sort will override the boost.

So, you either move your sort into boost by making that condition map into boost values.

Or you move your boost condition into sort, using query() syntax. This was one of the gems from the Lucene/Solr Revolution 2016 presentation by hoss (click start presentation):

        qq = Harry
         q = +{!edismax v=$qq}
        qf = title actor writer director  keywords
      sort = query($title_sort,0) desc, title asc
title_sort = {!field f=title v=$qq}

solr boost query with separate sort

2 Answers