You are here:
Using the Filter Node
The filter node uses the selected operator and value to keep or remove data based on whether any or all of the specified conditions are met.
| equal | Returns values that are equal to the specified value. |
| not | Returns values that are not equal to the specified value. |
| is null | Returns a null value when conditions are met. |
| is not null | Returns a not null value when conditions are met. For example, filtering a field to ensure that the value exists. |
| less than | Returns values that are less than the specified value. |
| less than or equal to | Returns values that are less than or equal to the specified value. |
| greater than | Returns values that are greater than the specified value. |
| greater than or equal to | Returns values that are greater than or equal to the specified value. |
| is empty | Returns empty values. For example, an empty string is a string with zero length. |
| contains | Checks if the given value can be found in the results. |
| does not contain | Checks whether the specified value is not present in the results. |
| contains regular expression | Checks whether the specified matching string is present in the results. |
| does not contain regular expression | Checks whether the specified matching string is not present in the results. |
| Relative DateTime | Expresses a date and/or time value that changes based on the current date and time. Intervals include: Last N Days, Hours, Minutes, and Seconds Next N Days, Hours, Minutes, and Seconds |

