Filter Node
- Yashna Chhatwal (Unlicensed)
Filter Node JSON object:
{
"id": 91261177,
"typeOf": "filter",
"parentId": 76681284,
"rootId": 76250695,
"workspaceSlug": "montecarlo",
"authenticationId": null,
"title": null,
"paused": true,
"versionCode": "77676@1.0.0",
"resorceSlug": "filter",
"params": {
"filter_criteria": [
[
{
"key": "76250695##customer##first_name",
"value": "",
"match": "icontains" },
{
"key": "76250695##customer##last_name",
"value": "shopify",
"match": "icontains" }
],
[
{
"key": "76250695##total_price",
"value": "2000",
"match": "igreater" }
]
]
},
"meta": {
"parammap": {},
"selectedGives": {}
},
"isTemplate": false,
"createdAt": "2020-01-20T05:13:04+00:00",
"updatedAt": "2020-02-07T13:14:06+00:00"
}
Params explanation for a Filter:filter_criteria in Params contains the list of all the filter objects added to the automation.
Multiple criterias added using AND logic fall in the same list, whereas criterias added using OR logic are added in a different list.
Field Name | Business Purpose | Field type (with size) |
|---|---|---|
filter_criteria | List of all the filter objects added to the automation | Array[Object] |
filter_criteria[].Key | Field on which the criteria filter is applied | String |
filter_criteria[].value | The field that matches the criteria | String |
filter_criteria[].match | Condition(Criteria) to specify when the automation can continue | Enum(Types of criteria) |
Types of criteria:
Types of Filter | Filter Rules | Match Parameter |
|---|---|---|
Text | Contains | contains |
| Does not contain | notcontains |
| Exactly matches | exact |
| Does not exactly match | notexact |
| Is in | reversecontains |
| Is not in | notreversecontains |
| Starts with | startswith |
| Does not start with | notstartswith |
| Ends with | endswith |
| Does not end with | notendswith |
Number | Greater than |
|
| Less than | less |
Date/time | After | dategreater |
| Before | dateless |
| Equals | dateequal |
Boolean | Is true | true |
| Is false | false |
Generic | Exists | exist |
| Does not exist | notexist |