The advanced search box is available for more specialized queries filtering different scopes, properties and free text clauses.

Find documents with

The standard advanced search web part uses FREETEXT SQL clause for "find document with..." keyword terms. Below samples are shown of how keywords are translated:

 

All words (AND)

Keywords: john smith     

SQL clause: freetext(defaultproperties, '+john +smith')

 

Phrase

Keywords: "john smith"

SQL clause: freetext(defaultproperties, '"john smith"')

 

Any words (OR)

Keywords: john smith

SQL clause: freetext(defaultproperties, ‘john smith’)

 

Note, this is how the hidden object submits the OR query by using the freetext(defaultproperties, ‘john smith’)  – However, if the query is done using the Search WebService it will interpreted it as an AND query. This is most likely because the hidden object uses KeywordInclusion.AnyKeyword on the FullTextSqlQuery object.

 

None of words (NOT)

Keywords: john Smith

SQL clause: freetext(defaultproperties, '-john -smith')

 

The different clauses work across the different keyword inputs, fx:

All words

Keyword: john

None of words

Keyword: Smith

SQL clause: freetext(defaultproperties, '+john -smith)

 

Property restrictions

 "Add property restrictions..." allows the user to select filtering on individual properties, like author, title or description. The properties will change depending on the selected result type. The available properties for All results are the following:

Author

Description

Name

Size

URL

Created date

Last Modified Date

Created by

Last Modified by

 

You can add your own custom properties by 1) mapping the crawled property to a managed property and 2) changing the result type xml of the advanced search web part to include the property. Using the result type xml you can also add new types of results for specialized content types.

 

Even though the user interface says "contains" in the operator drop down,  it is important to note that that it actually doesn’t use a CONTAINS SQL  clause. Instead it uses a LIKE statement, for example a property search on author is translated to the following clause:  (Author LIKE '%john%').

 

 None of the search component use the CONTAINS clause. That means that asterisk (*) cannot be used as wildcard operation in any of the standard search web parts and UI.

 

Note, adding property restrictions to the query will most like slow down the query.

 

Scopes

As a final option the advanced search gives to the possibility to filter results based on either language, item type or site scope.