Search/Filter Panel The Search/Filter Panel allows you to define the panels for search, filter, and replace in the web part. The Search/Filter Panel contains the following elements: Table 9. Search/Filter Panel Element Description Searched Fields See Searched Fields. Turn On List Searcher Mode Allows you to perform a search before the chart view displays any data. 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. Filter Usage Criteria Allow you to pass the filter criteria to the DAO provider layer. There are three options in this property: • PassToDAOProvider — The filter criteria is passed to the DAO Provider. When you select this, the filter criteria will not be used to filter the data that is returned by the external system (because the SI List View assumes that the data has been filtered by the external system). • FilterData — The filter criteria is used to filter the data that is returned by the external system. • PassToDAOProviderAndFilterData — The filter criteria is passed to the DAO Provider and is used to filter the data that is being returned by the external system. When you select PassToDAOProvider or PassToDAOProviderAndFilterData, you can use the filter criteria as parameter values in the operations in the Catalog property. In order to do so, you specify the parameter source as Input and the source name as: • FieldName.Value — allows you to retrieve the value that is entered by the user in the Filter panel for a specific field. • FieldName.MaxValue — allows you to retrieve the maximum value that is entered by the user in the Filter panel for the field that has Between operator, such as DateTime field. • FieldName.Operator - allows you to retrieve the operator that is specified by the user for a specific field. There is a possibility that your back-end only handles "Equals" operator. In that case, you can use the FixedOperator="Equals" attribute in the Searched Fields property so that the user can only use the 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. Searched Fields This property defines what fields are displayed in the Search Filter panel. 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. You can further edit fields using the following elements: Table 10. Searched Fields Element Description Advanced Mode Turn on if you want to edit Searched Fields in XML 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 list 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 If selected, 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 list. The field name is case sensitive. Sort Order Allows you to sort the values in ascending or descending order. AutoPostBack When selected, causes 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 list. 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 list. Display Format Indicates the format of the value that is displayed in the list. 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 < and >, 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. NOTE: For more information, see Display Format 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.
