NEST c# Query Creating SORT in Foreach - ElasticSearch

Question

I have the following code to construct a SORT query inside a foreach loop, however my problem is this will replace my old sort descriptor with latest one.

SearchDescriptor<MyDTO> nQuery = new SearchDescriptor<MyDTO>();
foreach (var sort in criteria.SortQuery.OrderBy(o => o.SortPreference))
                {
                  nQuery=  nQuery.Sort(s => s.Field(sort.SortName, sort.SortOrder));
                }

How to achieve this inside a ForEach

Rob · Accepted Answer · 2016-02-29 09:23:14Z

4

You can do this by

var sortDescriptor = new SortDescriptor<Document>();

foreach (var sort in sortCollection)
{
    SortOrder sortOrder;
    var tryParse = Enum.TryParse(sort.Order, out sortOrder);
    if(!tryParse) up to you how you are going to handle incorrect sort order
    sortDescriptor.Field(sort.FieldName, sortOrder);
}

client.Search<Document>(s => s.Size(0).Sort(sort => sortDescriptor));

Hope it helps.

answered Feb 29, 2016 at 9:23

Rob

9,9793 gold badges45 silver badges47 bronze badges

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

1 Comment

TBA Over a year ago

Thanks Indeed I went with this :)

Collectives™ on Stack Overflow

NEST c# Query Creating SORT in Foreach - ElasticSearch

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related