Sort by multiple fields in specific order in Solr

Question

So I want to sort my Solr response by the following fields:

published_year (desc)
series_number (asc)
status_color

Problem is that status_color must be sorted by the following values (e.i. not alphabetically):

"Green"
"Yellow"
"Red"

This field may only contain one of these values.

I'm hoping theres a way of doing this in the Solr query instead of massaging the result in code. With a result of hundreds of thounsands of documents it's not really an option.

Any help is appreciated.

score 3 · Answer 1 · edited May 23 '17 at 10:29

3

I think the answer for this question will be valid for you too:

Is it possible in solr to specify an ordering of documents

edited May 23 '17 at 10:29

Community

1
1

answered Oct 14 '14 at 14:27

Yann

1,019
1
8
18

score 3 · Answer 2 · answered Oct 15 '14 at 20:39

3

I believe Solr has Enum types, though I have never seen them used in a while. But they would be a perfect match, so worth a try.

answered Oct 15 '14 at 20:39

Alexandre Rafalovitch

9,709
1
24
27

This is very interesting. Are enum values sorted by their position in the config? – Fredrik Oct 17 '14 at 08:27

Sort by multiple fields in specific order in Solr

2 Answers2