Iterators

What is an Iterator?

An Iterator allows you to loop over a piece of data, for example a list, and do different things with it. For example you can iterate over each row in a database and inside of each loop you can check if it meets certain conditions, you can modify the database row, and so on.

You can access iterator-specific variables, e.g. Total Iterations, which shows how many iterations the iterator will do in total, or iteration-specific variables, e.g. Iteration Number which shows what number the current iteration is.

What Iterators are there?

Here are a few of the most common:

Get Rows Sorted by Column - Runs the code once for each row in a database, sorted by a column

Get Rows by Values - Runs the code once for each row with specific column values in a database

Loop - Runs the code a specified number of times

Get Channels - Runs the code once for each channel in a specified server

Split String Iterator - Runs the code once for each “Segment” that the string is split into