Filtering

The Filtering page allows you to use CAML filters to dynamically filter records or use Complex Filters to define static filter for the data.

The Filtering page contains the following:

 

Table 11. Filtering

Element	Description
CAML Filter	Allows you to specify the CAML (Collaboration Application Markup Language) query expression to filter your data. CAML is an XML-based query language. The CAML Filter will only be applied to the data. The filter will not be applied to the responses. NOTE: If you are using an external list created from SQL, CAML Filter is not supported for the following SQL data types and corresponding operators: • Int/Tinyint/Smallint/float and 'Begins With' & 'Contains' • Bit (Boolean) and 'Contains' • Money and 'Contains' NOTE: For an organization chart, the CAML filter will only work if the selected data source for the chart is a SharePoint list. For more information, see CAML Filters
Complex Filter	Allows you to use the Complex Filter expression to define a static filter for the data. The complex filter is applied to the data after the CAML Filter is applied. NOTE: The Complex Filter is provided here only for backward compatibility reason. In the past, Complex filter was used to support date functions. For more information, see Complex Filters