Filter data-list by matching
Description
Filters a data-list by field, you can add multiple predicate values into a text or number list
Input Ports
Name | dataType | sourceType | required | description |
---|---|---|---|---|
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 list 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 that should be filtered using the operation and predicate list value |
Scenarios
- The user wants to filter a data-list with a field of type
text-list
andequals
operation - The user wants to filter a data-list with a field of type
text-list
andnot equals
operation - The user wants to filter a data-list with a field of type
text-list
andcontains
operation - The user wants to filter a data-list with a field of type
text-list
andnot contains
operation - The user wants to filter a data-list with a field of type
number-list
andequals
operation - The user wants to filter a data-list with a field of type
number-list
andnot equals
operation
Use case
Linked port predicate list
Inputs
- Field name:
title
- Field data type:
text-list
- Operation:
Equals
- Predicate text-list:
- 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
iscontains
, the process will return everything that contains thepredicate
value
Search Tags
Filter data-list by mathcing each row with a list of values