Orderby on Displayname

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

Home / Forums / Developers (Apps and Integrations) Forum / Search & Navigation /

Mark Entius

Vote:

Hi,

When using OrderBy in a Find Query:

 query = query.OrderBy(x => x.DisplayName);

We're seeing results like this:

1. bed & onderschuifbed Doppia

2. box Ambra vlak - 2-persoons

When we would like the Ambra to be above the "bed & onderschuifbed". Is this because of the ampersand? And how can we get Find to order this by alphanumeric only (if that's a solution in this case)

Thanks!

/Mark

#187871

Feb 05, 2018 11:58

David Knipe

Vote:

Hi Mark

I suspect the ordering is because of the &. If you wanted more control of the ordering you could add an IncludeField convention to add a custom DisplayNameOrder field to the index then order by that. The DisplayNameOrder() delegate method can then parse/remove items from the display name to allow you to fully control the ordering.

More information:

https://world.episerver.com/forum/developer-forum/EPiServer-Search/Thread-Container/2015/5/best-pratice-for-including-information-that-does-not-exist-on-content/

https://world.episerver.com/documentation/developer-guides/find/NET-Client-API/Customizing-serialization/Including-fields/

https://world.episerver.com/forum/developer-forum/EPiServer-Search/Thread-Container/2015/9/epifind---how-to-index-additional-fields/

David

#187899

Feb 05, 2018 21:34

Mark Entius

Vote:

Hi David,

Thanks for your response. I will look at your suggestions.

/Mark

#187907

Feb 06, 2018 8:48

This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.