I’ll start this post with a revised version of “Mikael’s managed property rule of three”, now called “Mikael’s managed property rule of four”:
- Never ever mess with the out of the box managed properties.
- Use automatic/implicit managed properties if possible.
- Map crawled properties (the plain ows_columnname ones) to the RefinableXXYY re-usable properties if possible. And do give them a unique alias for easier management and use.
- If you want the value searchable in addition to refinable, ensure you read Side effect of mapping crawled properties to refinable managed properties.
- Create a custom managed property as last resort – which is only possible for Text and Yes/No columns.
Following these four rules will make your life easier, and help out troubleshooting search issues you might encounter.
Sometimes you think you know it all and then SharePoint search throws you a curveball. It’s been dormant all these years as it’s pretty much an edge case, but knowing this trick you can effectively break SharePoint search experiences quite magnificently :) Sounds fun right?
Note: You need access to the tenant search schema to break search experience globally, or employ this on your own site collections for mayhem and otherwise rendering yourself unpopular.