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-listandequalsoperation - The user wants to filter a data-list with a field of type
text-listandnot equalsoperation - The user wants to filter a data-list with a field of type
text-listandcontainsoperation - The user wants to filter a data-list with a field of type
text-listandnot containsoperation - The user wants to filter a data-list with a field of type
number-listandequalsoperation - The user wants to filter a data-list with a field of type
number-listandnot equalsoperation
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-rowsare empty, the process will continue and provide you with an empty data-list - If the
operationis false on every iteration, the process will continue and provide you with an empty data-list - If the
operationiscontains, the process will return everything that contains thepredicatevalue
Search Tags
Filter data-list by mathcing each row with a list of values