Filter processor is a tool with which you can manipulate and group the database records to filter out those records which meet specific criteria.
All the Filter tabs have the following columns:
- Column - Row numbers
- Name - Field names
- Type - Data Type
- When - Type of Filter Condition
- Condition - Value of filter condition (Dynamic Parameter allowed)
When | Condition | Remarks |
---|---|---|
– Equal / Not Equal – More Than / Not More Than – Less Than / Not Less Than |
Type : Comparable types: String, Numeric, Data, Timestamp Example : 10 1961-08-26 |
This condition uses a simple comparison of values, which must both be of comparable types. For example, strings can be compared with strings, but not with dates. |
Matches / Not Matches |
Type: String Example: US∣Mex |
This condition allows a regular expression to be used. Use of operators like “∣” for OR and “&&” for AND relationship. This example will match USA or Mexico strings. |
In Range / Not In Range |
Type: Numeric, Date, Timestamp with “~” as a separator Example: 1998-01-01~1998-12-31 |
|
In DataSet / Not in DataSet |
Type: Matching field type from another datasource Example: See Remarks |
repository:/Sample/DataSource.ds:Field1 This retrieves the matching field from another datasource for filtering values. |
Null / Not Null | Nothing to enter | Check whether if there is no content. Note that zero value is not considered null. |
JavaScript / Not JavaScript | Enter a script condition by specifying the matching type. Example: Field1==5∣Field2==“US∣Mex” where Field1 is numeric and Field2 is string. |
This is useful for entering multiple conditions or complex conditions using standard JavaScript. |