tFilterRow example
In the following example, the tFilterRow component, labelled filter_records, is used to get a list of people, based on the following conditions:
- the last name contains 9 or less characters
- the age is between 10 and 80 years
- the gender is male
- the hometown city is Chicago or New York
setSettings {
LOGICAL_OP : "&&",
CONDITIONS {
INPUT_COLUMN : "lastName",
FUNCTION : "$source == null? false : $source.length() $operator $target",
OPERATOR : "<=",
RVALUE : "9",
INPUT_COLUMN : "gender",
FUNCTION : "",
OPERATOR : "==",
RVALUE : "\"M\"",
INPUT_COLUMN : "age",
FUNCTION : "",
OPERATOR : ">",
RVALUE : "10",
INPUT_COLUMN : "age",
FUNCTION : "",
OPERATOR : "<",
RVALUE : "80"
},
USE_ADVANCED : "true",
ADVANCED_COND :
"input_row.city.equals(\"Chicago\") || input_row.city.equals(\"New York\")",
LABEL : "filter_records"
}