Query Data
The Query Data block is a more advanced way to retrieve data from storage and allows you to search for specific data or aggregate on record sets (e.g. counting and sums).
| Field | Description |
| Query Type | All items as array: Return all items in the query as a collection
Get Sums and Counts: Returns total sum, count, min, max average of the record set. This could only be used when there is only one numeric key in the group and record set |
| Group Name | The grouping name of the data to query |
| Record Name | The record name of the data to query |
| Filter 1 | Used to filter records that are only greater than a certain amount |
| Filter 2 | Used to filter records that are only greater than a certain amount |
| Order By | The order (asc or desc) to query the records in |
| Number Of Records | The maximum number of records to return in the query |
| Reverse Order | Used in conjunction with number of records and will reverse the final set of records returned |
| Output Array Variable | The name of the variable to store the final result set in - this is what is referenced in other stages |
The Order By & Reverse Order can be used in specific situations to return an appropriately ordered set. For example, let's say you have a list that is numbered from 1-100. Returning 10 records in descending order will return 100,99,98..91. If you set the reverse order to true, it will return 91,92,93..100