Sorting on Multiple Fields

nest
user3749920 picture user3749920 · Sep 17, 2014 · Viewed 7.9k times · Source

Does Nest support sorting on multiple fields? For example, say I want to sort first by FieldA ascending and then by FieldB descending.

My current approach looks something like this:

searchDescriptor.Sort(s =>s.OnField("FieldA").Ascending().OnField("FieldB").Descending());

But the "FieldB".Descending() part seems to be the only sort option that is sent to elasticsearch.

Does anyone know if there is another way to accomplish this?

Answer

Greg Marzouka picture Greg Marzouka · Sep 17, 2014

You are adding multiple fields on the same sort descriptor, which is overriding the previous value. Instead, you need to specify a new sort descriptor for each field:

searchDescriptor
    .Sort(s => s
        .OnField("FieldA")
        .Ascending()
    )
    .Sort(s => s
        .OnField("FieldB")
        .Descending()
    )

Related questions

Filter items which array contains any of given values

I have a set of documents like { tags:['a','b','c'] // ... a bunch properties } As stated in the title: Is there a way to filter all documents containing any of given tags using Nest ? For instance, the record above would …

Read More
Get raw query from NEST client

Is it possible to get the raw search query from the NEST client? var result = client.Search<SomeType>(s => s .AllIndices() .Type("SomeIndex") .Query(query => query .Bool(boolQuery => BooleanQuery(searchRequest, mustMatchQueries))) ); I'd really like to …

Read More
How do I update an existing document inside ElasticSearch index using NEST?

I am trying to update an existing indexed document. I have indexed tags, title and owners field. Now when the user changes the title, I need to find and update the document inside the index. Should I update and replace …

Read More