Filter conditions specify restrictions on the fetched rows. Each filter condition represents a restriction on one of the data set table views. 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 BeforeFill event. For table views based on unbound tables, filter conditions are arbitrary strings that can be used by BeforeFill event code implementing the fetch.
Specifying the TableViewNames argument allows you to selectively fetch certain table views without affecting other table views in the data set.
If the TableViewNames argument is not used, table views with FillIgnore property set to True are not fetched.
Before fetching data, C1DataObjects fires BeforeFill event. You can either pass filter conditions to the Fill method or set them in BeforeFill event. BeforeFill event fires both on calling Fill and when the data set is filled at startup due to FillOnRequest = True. After filling the data set, C1DataObjects fires AfterFill event.