You cannot create query restrictions on Boolean-managed properties that have Yes/No restrictions or that have True/False restrictions in SharePoint sites

Article translations Article translations
Article ID: 972046 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Windows SharePoint Services 3.0

You cannot create query restrictions on Boolean-managed properties that have Yes/No restrictions or that have True/False restrictions in SharePoint sites. For example, if you create a query with the value fooboolean=true, and then you run the query, it returns no documents.

Microsoft Office SharePoint Server 2007

Consider the following scenario:
  • You create a new Boolean-managed property that has a Yes/No restriction.
  • You mark the Boolean-managed property to be used in scopes.
  • You map the Boolean-managed property to a crawled Boolean property that has a Yes/No restriction.
  • You create a scope on the Boolean-managed property and then you compile the new scope.
When you perform a crawl, the item count column for the new scope contains the word "error" instead of the item count of the items that match the scope rule.

Also, you cannot create query restrictions on Boolean-managed properties that have Yes/No restrictions or that have True/False restrictions in SharePoint sites. For example, if you create a query with the value fooboolean=true, and then you run the query, it returns no documents.

RESOLUTION

Windows SharePoint Services 3.0

To resolve this issue for Windows SharePoint Services 3.0, apply the following update:
  • 970946 Description of the Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (Sts.msp): June 30, 2009

Microsoft Office SharePoint Server 2007

To resolve this issue for Microsoft Office SharePoint Server 2007, apply the following update:
  • 970948 Description of the SharePoint Server 2007 Cumulative Update Server Hotfix Package (Coreserver.msp): June 30, 2009

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 972046 - Last Review: July 28, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Windows SharePoint Services 3.0
  • Microsoft Office SharePoint Server 2007
Keywords: 
kbfix kbqfe kbexpertiseinter kbsurveynew kbprb KB972046

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com