I've created a list with local columns of Currency type. I created managed properties of text type by going to site collection level 'search schema' and waited for Full crawl to run. This didn't work.

1. Why it did not work?
2. How can I map local list columns to managed properties to utilize search?

Edit: I just opened another thread so understand if I can use managed properties created at SSA at site

  • that list search box sucks hard, an answer would help me also Aug 15 '17 at 20:00
  • @Colbs, did you try any fix around it? technically local columns doesn't generate managed properties so search box will not show anything. I'm looking for right place to generate managed properties in such scenarios.
    – vikbehal
    Aug 15 '17 at 20:02
  • I haven't tried but you can create managed properties in the Term store and add them as Site Columns or just create managed property on the list Aug 15 '17 at 20:26
  • you'd have to create it as site column not list column.
    – Aveenav
    Aug 15 '17 at 20:54
  • What is the desired behavior? Do you want to be able to use it as a refiner, for example, query items between $5 and $10? Aug 15 '17 at 21:13

Note: This answer is submitted as research and as partial answer for non number/currency type columns.

From my research til now it seems all columns except number and currency columns would be searchable. For number/currency columns we need to create managed property which is searchable to achieve same.

Unfortunately, at site collection we can only create managed properties of type text and yes/no type. When I mapped crawled properties - for currency columns - search didn't show anything after full crawl.

Next - Since mapping currency type crawled properties to text didn't show up anything after search, I'm looking for a method to enable this.

Pls. follow this great explanation by Mikael.


Sharepoint will create Managed Property automatically for you. But, you need to add at least one value for the field. Therefore, you can follow steps bellows:

  • Created a list with local columns of Currency type

  • Add first item with value in column Currency

  • Run Full Crawl or Incremental Crawl.

  • Check your Managed Property.

If you want to create custom mapping between Managed Property and Crawled Property, check this link for details https://technet.microsoft.com/en-us/library/jj613136.aspx

  • That's a crawled property. You then need to create a managed property and associate the crawled property with it, then perform another full crawl. The only time a managed property is auto-created is if the column is a site column and then associated with a list (or managed metadata but I'm not sure on the specifics of that)
    – Greg W
    Aug 16 '17 at 5:52
  • To add to GregW, automatic Managed Properties is only in SP2013, in 2016 and SPO MS crippled the feature. Aug 16 '17 at 12:05
  • @MatthewMcDermott, Thanks for sharing. So in SP2016 we create Managed properties even for Site columns?
    – vikbehal
    Aug 16 '17 at 15:23
  • @GregW, Predefined properties like 'refinablestring' are present at sub-site, site-collection and 'central admin' as well. My concern is which one right to use? Also, I'm unable to find documentation which tells the difference. Further, I tried creating a text type managed property at site collection and re ran full crawl. Search is unable to show any result.
    – vikbehal
    Aug 16 '17 at 15:27
  • @vicbehal, that has been my experience. You will see some Managed Properties created, sometimes, but they are not decorated with any functional attributes like they are in 2013. If you reuse the Refinable properties, just choose the ones whose data type serves your purpose. Aug 16 '17 at 15:42

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.