The filter is used to filter the records as per the given criteria. Filter that reads data in and manipulates the data to fit another output pattern or removes data that may not be needed.
...
Filter Designer integration-
...
AND: The logical AND operator is an operator that performs a logical combination of two statements. It receives the value "TRUE" only when both statements are true. If one of the two statements is false, the logical AND operator returns the value "FALSE".
OR: The OR operator is a Boolean operator that returns TRUE if one or both operands are TRUE
NOT: Operators that can be used to create a new compound statement from two or more statements. It reverses the truth value of any statement it appears before.
...
Add Condition
This is used to add multiple conditions using the “+” icon.
...
Add Group Condition
It is used to add multiple conditions to a group using the “Add Group“ icon
...
Filter Operators
Equals:
The equal operator is used to compare two values or expressions. It is used to compare numbers, strings, Boolean values, variables, objects, etc. The result is TRUE if the expressions are equal otherwise it's FALSE.
...