I’m not going to introduce the Search web parts in SharePoint in this article. I’m sure there are plenty of articles about that.

Today I’m looking at the managed properties in Office 365 as this is something that is different form the on-premises equivalent.

Out of the box the managed property for Title doesn’t have sortable set :

Title

This is probably not too much of a problem if you could simply edit the property and set sortable to yes

sortable

Unfortunately the sortable option is something that you can’t modify.

So where does that leave me, if I need to sort by title.

Create a new managed property? No for new properties this is also disabled!

Did Microsoft remove the sortable option in Office 365? No, they just hid it a bit.

There are many managed properties that start with Refinable… that do have the sort option enabled. These refinable properties are meant to be used by refinement panels. But there is no reason why they can’t be used in search web parts.

Refinable

For each data type (String, Date, Int, …) there is a different set of properties.

RefinableString00, RefinableString01, … all the way up to 20. “WHAT ONLY 20???”, I hear you shout.thXNP4Y9YD

Within Office 365 there are 20 Refinable Properties created for each datatype. Whenever you run out SharePoint will as by magic create another 100. And when you run out again another 100 are created.

So back to the original question of how to make Title sortable. Pick an unmapped Refinable property and map it to the Title fields. Then use that Refinable property in your search web parts and you can sort by Title.

Advertisements