ICachedDataset.Filtered

Syntax

Filtered: Boolean;

Description

The Filtered property determines current state of data filtering in cache.

Comments

If the property is set to True, the data is filtered by condition set in the Filter property, if False, the filtering is not performed.

Example

Sub Main;

Var

MB: IMetabase;

DSInst: IDatasetInstance;

Cache: ICachedDataset;

i: Integer;

Begin

MB := MetabaseClass.Active;

DSInst := MB.ItemById("Table_1").Open(Null) As IDatasetInstance;

Cache := DSInst.OpenCached;

Cache.FetchToRecord(Cache.RecordCountAll);

Cache.Filter.AsString := "Num1 < 30";

Cache.Filtered := True;

i := Cache.RecordCount;

End Sub Main;

After executing the example, all records are loaded into cache from a data source, then the filter (filtering condition - Num1 <30) is set, and the "i" variable contains the quantity of records remaining after filtering.