How to display more than one record from a query on the same page

Wappler General Need Help
1

Hi,
sorry for asking this dumb question but I just cannot work it out and have searched and read and tried a few things.

I have a query that returns multiple rows. I want to show these on the one page, not using buttons like in the iterator to go from one record to the next.

I have one record displaying lovely in a container, so I would like to repeat that container on the same page, one container for each DB record returned.

So I read up on the iterator but that seems to be used with the next/back buttons, so not what I am looking for.

Other examples always just drop all the rows from the DB query into a table, also not what I want.

I started to look at teh repeat/child repeat but couldnt seem to work that out, if that was the right thing to use, and if so could not work out how to use it, i added the repeat to the app, then i tried adding the repeat children above the container (to drag the container into it, but that woudlnt allow me)

this must be a simple thing to do, but I just cant work it out :frowning:

Thanks in advance
Darren

2

The repeat region is exactly what you need to use.
Add a repeat region/repeat children region, select your database query as an expression for it and bind the data inside.

3

thanks, do I need to have both, the repeat and repeat children? both using the query as the expression? thanks

4

got it working, you cant do a child repeater on a container, but can on the row

5

The repeat region repeats the element it is applied on.
The repeat children repeats the child element(s) of the element it’s applied on.

1 Like