The FQL Property Specification

SharePoint 2010

Last modified: April 30, 2010

Applies to: SharePoint Server 2010

A property specification limits the scope of the affected expression to specific regions of the indexed content. Such a region can be identified by a full-text index or a managed property.

Managed properties of type Text and Boolean are evaluated as text. All other managed property types, including the Datetime type, are evaluated as numeric values.

If you do not include a property specification for an expression, the search engine attempts to match the default full-text index defined in the index schema.

The property specification must always precede a colon (In operator), and numeric operators must always include a property specification.

Important note Important

The property specification must be in lowercase characters, even if the managed property name includes uppercase characters.

A property specification (the In Operator) may be applied to the following query entities:

  • A single term or phrase, as follows:

    body:"to be or not to be"
  • An operator, for example, the STRING operator, as follows:

    body:string("to be or not to be")

    In this case the property specification applies to the complete operator expression.

Each of the following expressions matches items that have both "much" and "nothing" in the title managed property.

title:and(much, nothing)

and(title:much, title:nothing)

title:string("much nothing", mode="and")