how can I limit by score before sorting in a solr query

Question

I am searching "product documents". In other words, my solr documents are product records. I want to get say the top 50 matching products for a query. Then I want to be able to sort the top 50 scoring documents by name or price. I'm not seeing much on how to do this, since sorting by score, then by name or price won't really help, since scores are floats.

I wouldn't mind if I could do something like map the scores to ranges (like a score of 8.0-8.99 would go in the 8 bucket score), then sort by range, then by names, but since there is basically no normalization to scoring, this would still make things a bit harder.

Tl;dr How do I exclude low scoring documents from the solr result set before sorting?

Answer 1

You can use frange to achieve this, as long as you don't want to sort on score (in which case I guess you could just do the filtering on the client side).

Your query would be something along the lines of:

q={!frange l=5}query($qq)&qq=[awesome product]&sort=price asc

Set the l argument in the q-frange-parameter to the lower bound you want to filter score on, and replace the qq parameter with your user query.

Answer 2

As observed by Karl Johansson, you could do the filtering on the client side: load the first 50 rows of the response (sorted by score desc) and then manipulate them in JS for example.

The jQuery DataTables plugin works fantastically for that kind of thing: sorting, sorting on multiple columns, dynamic filtering, etc. -- and with only 50 rows it would be very fast too, so that users can "play" with the sorting and filtering until they find what they want.