Add Results from a SharePoint Search or FAST Search to a Mashup

Use the

SharePoint Search block to use the results of a simple search in SharePoint as an information source. Complete the Server, Credentials and Site Properties and Simple Search Properties for this block.

Use the

SharePoint FAST Search block to use the results of an advanced search in SharePoint as an information source. FAST advanced searches use the FAST Query Language (FQL) to allow advanced searching such as wildcard matches, complex queries such as both terms present (AND/OR) or filtering results to specific properties.

Note:

The FAST search feature is not available in SharePoint 2007.

Connection

Select the connection for the SharePoint server with the site you want to search.

Note:

If no SharePoint connections have been configured in Business Analytics, this property shows a message and you cannot use this block until a connection to SharePoint has been configured by a Business Analytics administrator.

If the SharePoint server you need to work with is not in this list, contact your Business Analytics administrator.

User Credentials

This section is collapsed by default. It defines the credentials (user account and permissions) used to connect to this SharePoint server and sites. Use the

and

buttons to expand or collapse this section.

The permissions for the credentials you use determine which SharePoint sites and lists you can use in this block. Based on configuration, this may default to the credentials defined for the connection you have selected, also known as the service account. Or you may be required to supply your credentials for this SharePoint server.

Note:

Some SharePoint server connections may disable the use of user credentials based on configuration. In this case, this section only displays credential information.

To use your own SharePoint credentials to connect to this server, change or enter this account information and click Save.

Important:

Updating these credentials creates or updates your Business Analytics credentials for this SharePoint server (which are saved as Business Analytics User Attributes). This can affect other mashups or mashables that work with this SharePoint server if they use your credentials rather than the service account.

To remove your credentials from this block, click Remove. Depending on configuration for this server, the service account credentials may default. This also removes your Business Analytics User Attributes for this SharePoint server.

Site Name

Once you have the connection and user credentials set, choose the SharePoint site that you want to search.

Search Query	Enter a word or phrase to search for in this SharePoint site.
Start At	If desired, change the index number for the first result to return. This defaults to 1.
Count	If desired, change the total number of results to return. This defaults to 0 which returns all results.

Query Type	This defaults to Keyword which searches for simple text. Change this to FQL to use an advanced query expression to define what to search for.
Search Query	If the query type is Keyword, enter a word or phrase to search for in this SharePoint site. If the query type is FQL, enter a query in FQL for what to search for in this SharePoint site.
Spell Check	This option is set by default. It checks spelling within the keywords of the query and potentially returns other suggestions.
Resubmit if zero results	If desired, set this option to allow the search to turn off spelling checks and turn on stemming to attempt to find other results if an exact match does not find any results.