Creating Refinable and Sortable Managed Properties in Sites and Site Collections in SharePoint 2013


Someone was asking today about how to create a managed property at the site or site collection level that is refinable and sortable.  When you go into Schema Management at the site collection level you may notice that you can create new managed properties, but only simple ones that are based on string and you they have several attributes that you cannot change, such as whether they are sortable or refinable.  That is by design in SharePoint 2013; if you need to create new managed properties with those attributes then it can only be done at the Search Service Application level.  However, we do ship some "pre-baked" managed properties out of the box to enable this scenario, and in this post I'll try and explain how you use them.

 

If you go into the Site Settings and look at the Managed Properties in the Schema, do a search for Refinable in the list of managed properties.  What you'll find is that there are a BUNCH of them, of all different data types.  For example RefinableDouble, RefinableString, RefinableDate, RefinableDecimal, and so forth and so on.  For each one of these we actually include several properties – for example, RefinableDouble00 through RefinableDouble00 through RefinableDouble09, RefinableDate00 through RefinableDate19, etc.  The reason we include these managed properties, and multiple instances of them, is because they are all defined as refinable and sortable, and they map to different data types. 

 

So let's go back to the scenario we started with – suppose you create a new Choice field in your site collection called FavoriteColor.  You want to create a managed property for this field that is both refinable and sortable.  The first thing you want to do, as I've mentioned many times, is create a Site Column for the field; this will automatically create a crawled property for you.  Now in order to use it as a refinable and sortable field, you need to "connect" it with one of the Refinable* properties I mentioned above.  In this case, we will use RefinableString00.  So to do this connection, I'll go into Site Settings and click on Schema.  Then I'll type in refinables in the managed property list so I find RefinableString00.  If you click on that, you'll see that it is already mostly configured exactly like I want – refinable and sortable are both true.  There's really only two things I need to do – map my crawled property and give it an alias.

 

I'm going to give it an alias so I can refer to it using a name that makes sense, rather than RefinableString00.  So, in the alias field I type the name I want to refer to this crawled property by, which is "FavoriteColor".  Next, to connect this with the my crawled property I simply click on the Add Mapping button.  It brings up a list of all my crawled properties, and from there I can select ows_FavoriteColor, which I got when I added my Site Column (Note:  your crawled property names may vary, but you can always find it based on the Title you gave the field).  All I need to do now is save my changes and I'm done – I have a sortable and refinable property for my custom schema in my site or site collection, with a friendly name that I can use to refer to it by.  Here's a quick screen shot with all of these values filled in so you can see how it looks.

 

Comments (11)

  1. Anonymous says:

    Hi Steve.

    Brilliant as allways 🙂

    Could you give us a step by step on how to use managed metadata in the managed properties. In 2010 this was simple but I have yet to find a way in 2013. I have found how to add my managed properties to the refiner panel, I have found how to create managed properties, but I have not found a way to create managed properties based on terms in my Managed metadata catalog.

    Is this possible?

    Best regards // Thomas Balkeståhl – MVP SharePoint Server

  2. alexandrad9x says:

    Tao http://dichvuketoanlongbien.com/
    Rủa
    http://dichvuketoanlongbien.com/a2-96-dich-vu-ke-toan-tron-goi.html
    Thằng http://dichvuketoanlongbien.com/a2-98-dich-vu-ke-toan-thue.html
    Cờ
    http://dichvuketoanlongbien.com/a2-103-dich-vu-bao-cao-tai-chinh.html
    http://dichvuketoanlongbien.com/a2-97-dich-vu-quyet-toan-thue.html
    Nào
    http://dichvuketoanlongbien.com/a2-114-dich-vu-ke-toan-tai-29-quan-huyen.html
    Soi
    http://dichvuketoanlongbien.com/i780-dich-vu-ke-toan-thue-tron-goi-tai-bac-ninh.html
    Tài
    http://dichvuketoanlongbien.com/i779-dich-vu-ke-toan-thue-tron-goi-tai-bac-giang.html
    Khoản
    http://dichvuketoanlongbien.com/i778-dich-vu-ke-toan-thue-tron-goi-tai-phu-tho.html

    http://dichvuketoanlongbien.com/i781-dich-vu-ke-toan-thue-tron-goi-tai-hung-yen.html
    Link
    http://dichvuketoanlongbien.com/i782-dich-vu-ke-toan-thue-tron-goi-tai-vinh-phuc.html
    Của
    http://dichvuketoanlongbien.com/i783-dich-vu-ke-toan-thue-tron-goi-tai-hai-phong.html
    Tao. http://www.trungtamketoan.com.vn/
    Chúng
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-ha-noi.html
    Mày
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-tp-hcm.html
    Đủ
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-quang-ninh.html
    Trình
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-hai-duong.html
    Thì
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-bac-giang.html
    Tự
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-bac-ninh.html
    Đi
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-hai-phong.html

    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-nam-dinh.html
    Làm.
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-thai-binh.html
    Việc
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-thanh-hoa.html

    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-vinh-phuc.html
    Phải
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-hung-yen.html
    Rẻ
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-phu-tho.html
    Rách
    http://www.trungtamketoan.com.vn/p/trung-tam-dao-tao-ke-toan-tai-binh-duong.html
    Như http://www.tosvn.com
    Thế. http://iketoan247.blogspot.com
    Loại http://tailieuveketoan.blogspot.com
    Chó http://mauhinhnendep.blogspot.com
    Má. http://www.tosvn.com/search/label/Hack%20CF
    Tao http://www.tosvn.com/search/label/Hack%20AvatarStar
    Rủa http://www.tosvn.com/search/label/Hack%20Warcraft-Dota2
    Những http://hocketoan360.com/category/tai-lieu-ke-toan/
    Thằng http://iketoan247.blogspot.com/search/label/thong-tin-kinh-te
    Soi http://iketoan247.blogspot.com/search/label/tin-bai-ve-thue
    Tao http://hoclamketoan.edu.vn/
    Sẽ http://hoclamketoan.edu.vn/category/khoa-hoc-ke-toan
    Tan http://hoclamketoan.edu.vn/category/dich-vu-ke-toan
    Cửa http://hoclamketoan.edu.vn/category/hoc-lam-ke-toan
    Nát http://hoclamketoan.edu.vn/category/tai-lieu-ke-toan
    Nhà http://hocketoan360.com/
    Haha http://hocketoan360.com/category/khoa-hoc-ke-toan/
    http://hocketoan360.com/category/dich-vu-ke-toan/

  3. DanTheManXX says:

    I am trying to using this approach on custom properties I have added to the User Profile which each map to a term set in a similar way to OOTB Department. This I notice has two managed property entries in the /searchCenter search schema
    Hence I followed your blog post and mapped the crawl properties
    RefinableString00 is mapped to People:UserBU and ows_UserBU and has an alias of UserBU
    Did a full search and updated the mapped properties entry in my custom display template, attached to People Results Web Part

    ‘UserBU’:’UserBU’

    only I am getting no values displayed under the user and of course no refinement panel…does this look correct to you?

  4. Akthar says:

    Hi,

    I tried the exact same steps, but it seems that the return value of the Managed property is blank. Can you advise

  5. Ateet Agarwal says:

    Again Nice Post. It helping me a lot in Search.
    Thanks a lot Steve!
    Keep posting…nice article related to search

  6. Martin says:

    Thanks for this. Allows our business analysts to set up refiners on demo sites without needing operations folk.

  7. Miguel Uribe says:

    Great post! Thank you!

  8. Monali says:

    Thank you for the Great post.

  9. SAFD says:

    http://www.shopbestgoods.com/
    http://www.nike-jordanshoes.com/
    http://www.beatsbydreoutlet.net/
    http://www.michaelkorsus.com/
    http://www.polo-tshirts.com/
    http://www.northsclearance.com/
    http://www.ralph-laurensale.com/
    http://www.gucci-shoesuk2014.com/
    http://www.michael-korsusa.com/
    http://www.polo-outlets.com/
    http://www.ralphslauren.co.uk/
    http://www.marcjacobsonsale.com/
    http://www.mcmworldwides.com/
    http://www.salongchamppairs.com/
    http://www.canada-gooser.com/
    http://www.burberryoutlet2014.com/
    http://www.michaelkors.so/
    http://www.hermes-outletonline.com/
    http://www.oakley-sunglassoutlet.com/
    http://www.north-faceoutlets.net/
    http://www.moncler-clearance.com/
    http://www.woolrich-clearance.com/
    http://www.barbour-jacketsoutlet.com/
    http://www.moncler-jacketsoutletonline.com/
    http://www.monsterbeatsbydres.net/
    http://www.louis-vuittonblackfriday.com/
    http://www.lv-guccishoesfactory.com/
    http://www.mcmoutlet-jp.com/
    http://www.cheapdiscountoutlet.com/
    http://coachoutlet.iwopop.com/
    http://www.coachsfactoryoutlet.com/
    http://www.coach-blackfriday2014.com/
    http://www.coach-storeoutletonline.com/
    http://www.coach-factorysoutletonline.com/
    http://www.coachccoachoutlet.com/
    http://www.coach-factories.net/
    http://www.coach-pursesoutletonline.com/
    http://www.llouisvuitton-factory.net/
    http://www.coach-outletsusa.com/
    http://www.mksfactoryoutlet.com/
    http://www.zxcoachoutlet.com/
    http://www.mischristmas.com/
    http://www.misblackfriday.com/
    http://www.bestcustomsonline.com/
    http://www.newoutletonlinemall.com/
    http://www.clickmichaelkors.com/
    http://www.cmichaelkorsoutlet.com/
    http://www.ralphlaurenepolo.com/
    http://michaelkorsoutlet.mischristmas.com/
    http://mcmbackpack.mischristmas.com/
    http://monsterbeats.mischristmas.com/
    http://northfaceoutlet.mischristmas.com/
    http://mk.misblackfriday.com/
    http://coachoutlet.misblackfriday.com/
    http://coachfactory.misblackfriday.com/
    http://uggaustralia.misblackfriday.com/
    http://coachpurses.misblackfriday.com/
    http://coachusa.misblackfriday.com/
    http://coach.misblackfriday.com/
    http://michaelkorss.misblackfriday.com/
    http://michaelkors.misblackfriday.com/
    http://airmax.misblackfriday.com/
    http://michael-kors.misblackfriday.com/

    http://t.co/1PJuejI1ys
    http://t.co/FYm2MxWwLM
    https://twitter.com/CoachOutlet2014
    https://www.facebook.com/pages/Coach-Factory-Outlet-Online-Store-Michael-Kors-Outlet-Online-Sale-75-Off/712060898859091
    https://www.facebook.com/pages/Ralph-Lauren-Polo-Outlet-Online-Sale/1404100279810690

  10. APS says:

    Are site columns mapped to refinables unique per site collection? What is the implication if you search across site collections (e.g. refinablestring01 is mapped to a different site column in SiteCollectionA and a different column in SitecollectonB?

  11. Kati says:

    Which permissions are needed to modify managed properties? I’m a farm admin and a site collection admin, but could not change the managed properties on "Schema".