How to use a YesNo column to search against (without needing a FULL CRAWL)

Question

Hi,

Another search-related question ... I have Search Result Source that I want to use to return all documents of a specific Content Type AND where a given YesNo column is TRUE. So I created a YesNo column in SharePoint and added a document with the YesNo column set to 'Yes'.

Once the document was indexed, when I checked the Search Schema, I found the corresponding crawled/managed properties which were:

• ows_Complete --> Crawled Property
• CompleteOWSBOOL --> Managed Property

Since the managed property did not have any of its Query/Select/Search/Retrievable properties set, I mapped this property to an existing RefinableStringxx property which had all those properties set ... meaning I should be able to search for and retrieve items using this property without having to do a full crawl.

I then created my Result Source using the following query:

(ContentType="My ContentType Name") AND (RefinableString08:True)

However, I am not getting any results back. I know documents of the necessary type and YesNo values do exist. Any idea what is wrong with my approach? Am I missing something?

Thanks

Answer 1

Hi @Rene Wagner ,

According to your description, you have to do a Full Crawl operation.

This is because the Search service application administrator or site collection administrator added or changed a managed property. A full crawl of all affected content sources is required for the new or changed managed property to take effect.

For more information, please see this TechNet documentation.

Thanks,
Echo Du

===========================================

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.