Query repeat

Description

Loops over input data-list rows and runs linked commands for each text row within the input list, also allow you to specify the fields you want to retrieve from the data-list on each iteration and you can filter the list to only iterate over the data values that meets the operation criteria

Input Ports

Name	dataType	sourceType	required	description
Filter field name	text	manual-only	false	The field that will be used to filter through the data-list
Field data type	text	manual-only	false	The data type of the field that will be used to filter
Operation	text	manual-only	false	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
Fields	data-field	manual-only	true	The fields that exists within the data-items of the data-list
Data rows	data-list	link-manual	true	The data-list that should be repeated over

Scenarios

• The user wants to filter a data-list, repeat over a the filtered list and select 3 fields from the data-item
• The user wants to repeat over all the rows in a data-list and select 3 fields from the data-item
• The user wants to repeat over all the rows in a data-list

Use case

The query repeat command is a combination of the following commands:

• Repeat over data-list
• Filter data-list
• Select data-field from data-list

With Input and Output Ports

Inputs

• Filter field name: name
• Field data type: text
• Operation: equal
• Predicate text: Jack
• Fields:
  
• Start at Row number: 1
• Data rows: -
  -
  

Experienced tips

• If you specify a Field name, but leave the predicate value empty, the process will trigger the continue trigger and not iterate over any data-items in the original data-list
• If the filtered data-list is empty, the process will trigger the continue trigger and not iterate over any data-items in the original data-list
• If the data-list is empty, the process will trigger the continue trigger
• You are not required to specify all the fields to select from the iterated data-item
• If you run the query repeat command for the first time with no commands linked after the run loop trigger, the process will stop and provide you with the following error. Cannot read property 'targets' of undefined Ensure you have commands linked as targets after the run loop trigger.

Output

Search Tags

Select multiple values from a data-item Repeat over a data-list filter data-list