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-
List View
Report
Data Loader
Layout Designer
Workflow Actions
Model
Visibility, Disability, Read-only, Required Criteria
Data types (Work Done)
Text
Select
Multi Select
Integer
Double
Percentage
Record (Object)
Lookup
Email
Url
Duration
Date
Time
Date/Time
Checkbox
Tags
Text Area
Merge Text
Data types (Work Pending)
Array
Currency
Logical Operators
Logical operators are used to combine multiple conditions.
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.
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.
Start With:
It returns TRUE if a string or number starts with the specified character otherwise it returns FALSE
Contains:
The contains operator returns TRUE if the value on the left contains the value on the right, and otherwise FALSE.
End With:
It returns TRUE if a string or number ends with the specified character otherwise it returns FALSE
IN:
IN operator allows you to easily test if the expression matches any value in the list of values.
Determines whether the value of an expression is equal to any of several values in a specified list.
Greater Than:
Returns True if the value on the left side is greater than the value on the right side.
Less Than:
Returns True if the value on the left side is less than the value on the right side.
Greater Than or Equal To:
Returns True if the value on the left side is greater than equal to the value on the right side.
Less Than or Equal To:
Returns True if the value on the left side is less than equal to the value on the right side.
Between:
The Between operator selects values within a given range. The values can be numbers, text, or dates. The Between operator is inclusive: begin and end values are included.
All Of: If all records are filter which are present in input .
None Of: If all record which are present in input should not get filter
Any Of: If any one or more records are fetch present in input.
Match:
Match operator to compare a string expression with a pattern. returns true or false depending on whether its pattern matches the given string. The match operator supports these wildcard characters in the quoted string. Matches any of the enclosed characters, including ranges, as in [ a-z ].