Filter data-list

Description

Filters a data-list by field and value with different types of operations

Input Ports

Name	dataType	sourceType	required	description
Case Sensitivity	text	manual-only	true	Whether the user wants the filter to be case sensitive or not
Field name	text	manual-only	true	The field that will be used to filter through the data-list
Field data type	text	manual-only	true	The data type of the field that will be used to filter
Operation	text	manual-only	true	The operation that you want to happen between the predicate value and the field value of the data-list, Text and Number has different types of operations.
Predicate text/number	text/number	link-manual	true	The field value that should be used when filtering the data-list, can be text or number
Data rows	data-list	link-manual	true	The data-list that should be filtered using the operation and predicate value

Scenarios

• The user wants to filter a data-list with a field of type text and equals operation
• The user wants to filter a data-list with a field of type text and not equals operation
• The user wants to filter a data-list with a field of type text and contains operation
• The user wants to filter a data-list with a field of type text and not contains operation
• The user wants to filter a data-list with a field of type text and empty operation
• The user wants to filter a data-list with a field of type text and not empty operation
• The user wants to filter a data-list with a field of type number and equals operation
• The user wants to filter a data-list with a field of type number and not equals operation
• The user wants to filter a data-list with a field of type number and greater than operation
• The user wants to filter a data-list with a field of type number and greater than or equals operation
• The user wants to filter a data-list with a field of type number and less than operation
• The user wants to filter a data-list with a field of type number and less than or equals operation
• The user wants to filter a data-list with a field of type number and empty operation
• The user wants to filter a data-list with a field of type number and not empty operation

Use case

Inputs

• Field name: Name
• Field data type: text
• Operation: Equals
• Predicate text: Jack
• Data-List:
  • Fields:
    
  • Values:
    

Experienced tips

• If the data-rows are empty, the process will continue and provide you with an empty data-list
• If the operation is false on every iteration, the process will continue and provide you with an empty data-list
• If the operation is contains, the process will return everything that contains the predicate value

Output

Search Tags

Filter data-list rows