filterarray - Filter an Array by an Operator
Filters an array by an given comparison operator.
data
array
Array of lines with mixed values.
Minimum: 1
Example:
[
{
"Column1": "Germany",
"Column2": "Apple",
"Column3": 1,
"Column4": true
},
{
"Column1": "Germany",
"Column2": "apple",
"Column3": 2,
"Column4": true
},
{
"Column1": "US",
"Column2": "Apple",
"Column3": 3,
"Column4": true
}
]
queryField
string
Name of the field in data to look for critera. Case sensitive
Example:
Column3
operator
string
Comparison operator. Defaults to eq
Possible values are: eq, gt, ge, lt, le, ne
Example:
eq
criteria
string
Criteria to look for must be number or string
Example:
3
ignoreCase
boolean
Sets case sensitivity for operation.