1

I am working on a content search web part, which show a list of sub-sites under the current site collection. now i want to Sort the sub-sites inside the webpart using their site description field. and to do so i map the Refinablestring01 managed property with the ows_SiteDescription crawl property as follow:-

enter image description here

then inside my content search web part i chose to sort the results using the refinablestring01 managed property as follow:-

enter image description here

now the problem is that the sort i am receiving is case sensitive. as if i have a site with the following description "This site was created upon manager request" will be shown before a site with the following description "abc". so if the site start with an upper case it will always be shown before lower case. so is there a way to force a case-insensitve sort inside my content search webpart ? now if i change the first site description to start with a lower case as follow "this site was created upon manager request" then this site will be shown after "abc".. Thanks

5

In SharePoint Search, it will sort Character with "A-Z" then "a-z", it is by design, because Lower Case character will have a larger ASCII value compare with Upper Case character. SharePoint Search will sort based on ASCII value.

Case insensitive sorting in SharePoint

A workaround is that create a new field with all character converted to Lower Case character and then sort by the new field instead.

  • but i can not create a new field with all characters converted to Lower Case characters, as i am sorting sites not list items.. and for the site they come with built-in fields such as title, description, logo... so you mean there is not a way to fix the sort issue.. – john Gu Sep 27 '17 at 22:23
  • yes, it is by design to sort with ASCII value. – Jerry_MSFT Sep 28 '17 at 9:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.