Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Sorting Issue when sorting by date
Hi Joshua,
Your issue looks familiar :) This is known issue FIND-3596 and will be fixed in next versions.
For your case, the working around for OrderBy clause will be
.OrderBy(x => x.StartDateTime, null, SortOrder.Descending, false)
- make sure that IgnoreUnmapped params is false.
Hope this help.
/Son Do
Edited,
Jul 22, 2018 5:31
We are experiencing alot of issues with with orderby in our results. Especially happening with Dates and strings. The order by on a property Title for example puts abdominal at the end of the list and shows adolecent as the first item. Clearly not working. Another instance is the date.
Here is the result of 7 events sorted by date
var query = this.searchClient.Search();
if (q.HasValue())
query = query.For(q);
if (currentPage.EventTypes.HasValue())
{
var eventTypeFilter = this.searchClient.BuildFilter();
foreach (var eventType in currentPage.EventTypes.Select(x => x.ToReferenceWithoutVersion().ID))
eventTypeFilter = eventTypeFilter.Or(x => x.EventTypeIdList.Match(eventType));
query = query.Filter(eventTypeFilter);
}
if (currentPage.ScopeOverride.HasValue())
query = query.Filter(x => x.Ancestors().Match(currentPage.ScopeOverride.ToReferenceWithoutVersion().ID.ToString()));
query = query
.FilterForVisitor()
.ExcludeDeleted()
.Filter(x => x.EndDateTime.GreaterThan(DateTime.Now))
.OrderBy(x => x.StartDateTime)
.Skip(model.PageWeight * p)
.Take(model.PageWeight);
var results = query.GetContentResult(); We are using version 13.0.1.0