Provides a base class for all user input filters that the Business Data Connectivity (BDC) service supports.
Assembly: Microsoft.SharePoint (in Microsoft.SharePoint.dll)
BDC supports two types of filters:
User input filters User input filters require users to provide filter values just as the Comparison, Limit, and Wildcard filters.
System filters System filters are system-provided.
Following are the user input filters that BDC supports:
Limit filter Limits the number of instances returned to n. SQL supports this filter with the SELECT TOP clause. By using a Limit filter, you can prevent long waits, timeouts, and users from issuing bad queries that request large amounts of data.
Comparison filter Takes an operator and a condition and returns only the instances that meet the condition.
Wildcard filter Limits the instances returned to fields such as value, where value may contain the asterisk (*) wildcard character. Users can use this filter type to present more user-friendly filters such as "starts with" and "contains."