Can i Loop over Database and write single element into an array?

Need help
1

Hey guys,
my goal is to read the column of a database, e.g. names (string), via a loop and write the elements in an array. then i want to transform this array into html to fill a html block for specific visualizations later. but i cant find a solution for this case.

currently i can get an element from database and visualise it in front end. but only 1. does someone know how to use the loop to fill they array with the elements?

Current BPs:

Triggers of smartButton
Triggers of smartButton3186×1344 212 KB

the request get block is just using 1 GetOne and 1 Make blocks to pull the specific data from database

2

WAA_Datenauszug
WAA_Datenauszug1486×477 39.3 KB

3

okay found the “missing link”. with “set variable”-block and variable i can set up my loop as i need.

4

@Marcel problem solved?

5

yes, it is. thank you.