YOUSEFUL / DELPHI / COMPONENTS
TAtlasFilterOperator
The comparison of a TAtlasFilter: equal, not equal, contains and the four ordered comparisons.
Description
Report and dashboard JSON store the ordinal (0 to 6). Ordered comparisons are numeric on ackNumber columns and case-insensitive text comparisons otherwise; a missing value never passes them.
Members
| Member | Kind | What it does |
|---|---|---|
afEqual | value | Ordinal 0. |
afNotEqual | value | Ordinal 1. |
afContains | value | Ordinal 2. |
afLess | value | Ordinal 3. |
afLessEqual | value | Ordinal 4. |
afGreater | value | Ordinal 5. |
afGreaterEqual | value | Ordinal 6. |
Values
afEqual value
afEqualOrdinal 0. Equal; text without regard to case. With an empty value, matches missing cells.
afNotEqual value
afNotEqualOrdinal 1. Not equal. With an empty value, matches every cell that has a value.
afContains value
afContainsOrdinal 2. Case-insensitive substring. Text columns only; other kinds raise EAtlasAnalyticsError. An empty value matches no rows.
afLess value
afLessOrdinal 3. Less than.
afLessEqual value
afLessEqualOrdinal 4. Less than or equal.
afGreater value
afGreaterOrdinal 5. Greater than.
afGreaterEqual value
afGreaterEqualOrdinal 6. Greater than or equal.
Examples
Service sales outside the North region
afContains on a text column and afNotEqual.
uses Atlas.Data, Atlas.Analytics;
function ServiceOutsideNorth(Sales: TAtlasTable): TAtlasTable;
begin
Result := TAtlasAnalytics.Select(Sales, [], [
TAtlasFilter.Create('Product', 'serv', afContains),
TAtlasFilter.Create('Region', 'North', afNotEqual)]);
end;