Find in data-list by matching

Description

Finds a data-item in a data-list by field, you can add multiple predicate values into a text or number list. This command will return the first data-item where the operation return true.

Input Ports

Name	dataType	sourceType	required	description
Field name	text	manual-only	true	The field that will be used to find rows in the data-list
Field data type	text	manual-only	true	The data type of the field that will be used to find rows
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-list and Number-list has different types of operations.
Data rows	data-list	link-manual	true	The data-list you want to find rows in

Scenarios

• The user wants to find rows inside the data-list with a field of type text-list and equals operation
• The user wants to find rows inside the data-list with a field of type text-list and not equals operation
• The user wants to find rows inside the data-list with a field of type text-list and contains operation
• The user wants to find rows inside the data-list with a field of type text-list and not contains operation
• The user wants to find rows inside the data-list with a field of type number-list and equals operation
• The user wants to find rows inside the data-list with a field of type number-list and not equals operation

Use case

Inputs

• Field name: title
• Field data type: text-list
• Operation: Equals
• Predicate text: [Jack, French]
• Data-List:
  • Fields:
    
  • Values:
    

Experienced tips

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

Output

Search Tags

Find data-item in data-list by matching list values