The Compare Filter
The Compare Filter element is used with datalayer elements to filter out data rows. It's analogous to using a WHERE clause in a SQL query but, unlike a query, it's applied to the data after it's been retrieved into the datalayer.
The following topics discuss the Compare Filter element:
- Compare Filter Attributes
- Applying the Compare Filter
- Compare Filter Usage Examples
- Using Multiple and Dynamic Compare Filters
- Use with a Condition Filter
About the Compare Filter
The Compare Filter element is available for use with all datalayer elements and is particularly useful in conjunction with those lacking query capabilities, such as DataLayer.XML and DataLayer.Web Service.
In operation, the element basically compares a specified data column value against a specified literal or tokenized value and removes all rows from the datalayer where the comparison returns False. A variety of comparisons, such as Equal, Greater Than, Less Than, etc., are supported.
This element is quite similar to element, however, it frequently provides better performance because it's implemented as a native part of the Logi Data Engine and so does not need to execute script, as the Condition Filter does.