4

I have a content search web part inside my sharepoint 2013 on premises site. The content search web part will show all the sub sites I have inside a site collection .. now everything is working well.. but the problem is that I am unable to sort the sub sites by their Title,, as the sort list inside the content search web part does not contain the Title.. so can any advice on this please??

5

The title of a site (the one present on (/_layouts/15/prjsetng.aspx page) resides in a crawled property called ows_SiteName.

You should map it to a RefinableStringxx managed property(see below screen grab) and then click OK.

To do that, go to your Central admin > Manage service applications > Search service application > Search Schema (under queries and results)

enter image description here

Once the mapping is done, do a full crawl of the data source.

After that, you will be able to sort the results based on the site's title property.

  • @Gautm thanks for the help and the great explanation.. but i am wondering why sharepoint did not do this mapping out of the box? as it do for many other built-in managed properties? – john Gu Sep 15 '17 at 12:04
  • 1
    Well not sure why, but I guess the powers that be at Microsoft left it to the users/developers to do stuff they seem fit. Not everyone wants to sort based on site title, but if you want to do then the platform supports it !!! – Gautam Sheth Sep 15 '17 at 14:45
  • unfortunately i followed your steps and then i tried to sort using RefinableStringxx Ascending where i will get the correct order for the first items only, where i got the sites with titles starting with A, then B, then C,the D, and so on. but at the end of the search result i will get incorrect results.. here is sample of the order which i got Architecture >> Benchmark Electronic Design >> ...... >> Software and Systems Engineering>> Windows 7 Migration Investigation>>Enhanced Communication in C++ >> Supervised In-traning – john Gu Sep 18 '17 at 14:24
  • ..so Windows 7 Migration Investigation is being shown before Enhanced Communication in C++ !! – john Gu Sep 18 '17 at 14:24
  • can u please advice on the above comments? – john Gu Sep 18 '17 at 22:30
4

You can map title to one of the RefinableString, crawl, and sort by that RefinableString

UPDATE

Go to Central admin > Manage service applications > Search service application > Search Schema (under queries and results)

Find one RefinableString (for ex RefinableString00,RefinableString01...), edit property and add one of titles.

You can add ows_SiteName or one of the Title managed property (for ex. Basic:displayTitle). enter image description here

After that you have to recrawl (full crawl).

Then edit your wp and add sorting by RefinableString00 enter image description here

SORTING

Not so many predefined managed properties are sortable, maybe because MS implemented FAST Search with default sortable properties in SP2013.

You could also edit SiteTitle (ows_SiteName managed property) on CA > Manage service applications > Search service application > Search Schema.

Change sortable to Yes-active and recrawl.

On SPO you can't do that, only map to Refinable managed property


Link

Sorting has always been a big deal and highly requested feature in previous versions of SharePoint. You really couldn’t sort by many criteria at all without writing custom code. In SharePoint 2010, FAST Search for SharePoint added sorting capabilities but many people didn’t care to pay for it. Well, now sorting is a first class feature in SharePoint 2013. You can mark managed properties as sortable now and then use them in the search results web part. Note, that you can only do this for properties at the Service Application level.


EDIT 2

You could create new Result Source which would override your sorting on wp.

Go to Site settings>Site Collection Administration>Manage Result Sources Create new, give it name like Sort Site Title, under Query Transform Launch Query Builder and add sorting to your RefinableStringXX ASC.

Edit your CSWP (Content Search Web Part) and select your new result source under Select a query

link

  • can you please provide more info about this? thanks – john Gu Sep 12 '17 at 14:11
  • 1
    see my update or @gautam-sheth answer – Marko Tica Sep 14 '17 at 12:48
  • 1
    See updated answer under SORTING – Marko Tica Sep 18 '17 at 7:56
  • 1
    see updated answer under EDIT 2 – Marko Tica Sep 18 '17 at 14:51
  • 1
    no i check this again today an the sort is working well !!! although when i test this i did a full crawl.. – john Gu Sep 19 '17 at 13:53

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.