A filter condition specifies a restriction on fetched rows when a table view is filled with data, see Fill. For table views based on bound and SQL-based tables, a filter condition has SQL WHERE syntax with bracketed table view field names as variables (example: [CustomerID] = 'ALFKI'), except for a custom filter condition (IsCustom = True) which can be an arbitrary string for use in C1DataSet.BeforeFill event. For table views based on unbound tables, filter conditions are arbitrary strings that can be used by C1DataSet.BeforeFill event code implementing the fetch. See Bound, SQL-Based and Unbound Tables for details.

Reference

FilterCondition Members
C1.Data Namespace