Search/Filter/Replace Panel

The Search/Filter/Replace Panel allows you to define the panels for search, filter, and replace in the web part. You will be able to perform a search by pressing Enter.

NOTE: Pressing Enter will not allow you to perform a search on such fields as external data, people picker, managed metadata, and a drop-down list. Instead, the default behavior will occur.

The Search/Filter/Replace Panel contains the following elements:

 

Table 9. Search/Filter/Replace Panel

Element	Description
Searched Fields	See Searched Fields.
Fields Excluded from Replace Panel	Defines which fields from the list must be excluded from the Field Name drop-down menu in the Replace panel. The Fields element can contain one or more Field elements. The Field element can contain one attribute, which is the Name attribute. The Name attribute is the display name of the field to be excluded from the Replace panel. NOTE: Turn Advanced Mode on if you want to edit this field in XM L format. This property is an XML in this format: <Fields>     <Field Name="Field1"/>     <Field Name="Field2"/> </Fields>
Show Include Sub Folders Check Box In Search Panel	Determines whether the Include Sub Folders check box is displayed in the Filter panel. When you select this property and the Show Folders Button property in the Toolbar Appearance page, the Include Sub Folders check box will appear as the first row in the search/Filter panel. NOTE: Select this element when the folder panel is enabled and the view and the search are limited only on the currently selected folder. The Include Sub Folders check box is useful if you want to include the subfolders of the current folder in the search.
Show Search All Fields Control in Search Panel	Determines whether the Filter panel should display the control to search all fields in the list. When set to true, the following control is shown in the Filter panel: The Search All Fields Control allows you to do the following: • Combine the search all fields functionality with other search criteria that has been entered for specific fields. • When the search all fields criteria is entered, the Filter panel will construct a filter expression with the "Contain" operator for the following fields in the list: Single line of text, Multiple lines of text, Choice, Lookup (only Lookup to a Single Text field and Lookup to a Number field are supported), Person or Group and Hyperlink or Picture. If the list contains a Lookup to Number field, Search All Fields will not work for negative numbers for that field. The Filter panel will use the entire keywords as the value to be searched. Therefore, if you enter "High Priority" in the search all fields control and perform the search, it will find the following sentence: ‘This is a high priority task’ However, it will not find the following sentence: ‘The priority is not always high’
Expand Filter panel on Load	Allows you to automatically open the Filter panel by default so that the user can perform a search quickly. When set to true, the Filter panel opens when the web part is loaded for the first time.
Panel Button Location	Determines the location of the Go, Reset and Close buttons in the Filter panel. This property also determines the location of the Go and Close buttons in the Replace panel.
Turn On List Searcher Mode	Allows the user to perform a search before the listview display any data.
Show Filter On Fields	Allows you to display a filter control on the listview column headers. When this element is set to true, the filter control appears next to each column header. However, you can only use this element when the Turn On list Searcher Mode element is set to False. NOTE: This filter does not support SharePoint List fields such as Lookup, Choice (check box type), Person or Group, Multiple lines of text, Managed metadata (with multiple values), Hyperlink or Picture, Calculated (calculation based on other columns), and External data. The filter also does not support fields provided by the web part such as Edit, Type, Item Location, and Add Field (Custom field that supports fixed and calculated values). However, the filter control supports, SharePoint List fields such as Single line of text, Choice (radio buttons and drop-down list), Number (1, 10, 100), Currency ($, ¥, €), Date and Time, Yes/No (check box), Managed metadata (which accepts single value), and Task Outcome. The filter also supports the following fields provided by the web part such as List Name, Workspace URL, Folder, and Site Name. Also, the maximum number of options available in the filter checklist will only be the first 500 items that are displayed in the List View. You can filter items beyond this 500 items limit directly using the search options provided in the filter control.

Searched Fields

This property defines which fields are displayed in the Filter panel. If defined, the listview displays Filter or Search menu items under the Actions button in the toolbar.

NOTE: If the item count in the list exceeds the List View Threshold in SharePoint (see, http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx), the search will fail. Set the filter settings to lessen the item count, and set the search fields in the index. If the returned items, based on the search, return too many results, the search will still fail. NOTE: For the Number type field, the “Contain” operator is not supported for negative numbers, and is not available for the following fields: Lookup to DateTime field, Lookup to Calculated field, and Lookup to ID field.

To disable the search feature in the listview, leave this property blank.

The Searched Fields element can contain multiple Field elements:

 

Table 10. Searched Fields

Element	Description
Advanced Mode	Turn on if you want to edit Searched Lists in XML format. This property is an XML string in the following format:  <Fields>    <Field Name="fieldName" [optional attributes]/> <!-- To search a cross site lookup field, use one of the following two formats -->     <Field Name="fieldName" DisplayFieldName="fieldName" SortField="fieldName" [optional attributes]>         <List SiteUrl="siteUrl" SiteName="siteName" ListName="listName"/>     </Field>     <Field Name="fieldName" DisplayFormat="fieldName" SortField="fieldName" [optional attributes]>         <List SiteUrl="siteUrl" SiteName="siteName" ListName="listName"/>     </Field> </Fields>
Field Name	Indicates the element you are editing.
Title	Displays title for the field. The value can be a plain string or an encoded HTML string.
Description	Describes the field. This is useful if you want to give a short instruction or explanation about the field.
Default Value	Defines the default value for the field. You can define a text, a number or a date. A date value must be specified in ISO 8601 format: YYYY-MM-DDThh:mm:ssZ, for example: midnight of February 14, 2002 is 2002-02-14T00:00:00Z.
Default Operator	Defines the default operator for the field.
Fixed Operator	Defines the operator for the field. If specified, the drop-down menu to select the operator for this field is turned off.
Use People Editor	Enables you to enter any user information that is in your directory service. If you set this to True and the field to be searched is a People and Group field, the Filter panel will show the People Editor control for entering the search criteria.
Column Count	Defines the number of columns for the options in a multi-choice field or in a choice-and-lookup field if the Enable Multi Choice attribute is set to True. This is useful in case your choice or lookup fields have too many choices and you want to break the choices into several columns to minimize the vertical scrolling in your form.
Enable Multi Choice	Allows you to select multiple options for the choice-and-lookup field. Therefore, the user can specify a condition like "A or B". This attribute is ignored by other field types. To search a cross-site lookup field, you must specify one or more List elements inside the Field element. The cross-site lookup field is displayed as two drop downs.
Sort Field	Defines the field that is used to sort the value in the drop-down menu. The field name is case sensitive.
Sort Order	Allows you to sort the values in ascending or descending order.
AutoPostBack	Use the Filter panel to refresh when the user changes the selection in a lookup field or cross-site lookup field. You need to set AutoPostBack to true if this field is a lookup or a cross-site lookup field and it is being used to filter another lookup or cross-site lookup field in the Filter panel.
Parent Field	Defines another lookup or cross-site lookup field that is used to filter this field. The parent field must be listed before this field in the XML property.
Parent Filter Field Name	Defines the field in the parent field that is used to filter this field. It is the primary key in the list that is used in the lookup or cross-site lookup field.
Filter Field Name	Defines the field in the list that is used by this lookup or cross-site lookup field that is filtered by the parent filter field.
Display Field Name	Shows the name of the field whose value is displayed in the drop-down menu. The field name is case sensitive. Use this attribute instead of the Display Format attribute if you only want to display a single field in the drop-down menu.
Display Format	Indicates the format of the value that is displayed in the drop-down menu. Define this attribute instead of the Display Field Name attribute if you want to display multiple fields in the drop-down menu. You can use the field replacement expression <%Field%> to refer to a field. NOTE: If you are using Advanced Mode, you must use the encoded form of the < and > characters, which are &lt; and &gt;, respectively unless you type in the value in the Searched Fields editor in the List View Editor, where the Editor will encode the characters automatically for you.
Site URL	Indicates the Site URL of the field. You can use an absolute or relative URL.
List Name	Indicates the name of the List. The field name is case sensitive.
Site Name	Indicates the name of the site specified in the Site URL. This is used in case you have multiple lists. In this case, the first drop-down menu to select the list will display as "List Name in Site Name". You can use any name for the Site Name. It does not have to match the real title of the Site.