Hi there.
How do I do a nested repeat?

I've created a query that joins two tables of products and product options so I can list all the product options with the associated product name beside them.

What I want to do is list all the product names, and then in a box beneath each product name I want to list the options associated with that product.

Hi Bruce,
So you want to nest them on the server side or?

Please check this video - using the App Connect Formatter: www.dmxzone.com/go/32971/using-the-group-by-filter you can achieve this.

Hi Teodor

Watching the video it looks like I need to buy another extension from DMX for this (DMX App Connect Data Formatter).

Is there another way to do this without having to buy more software?

Thanks

You can nest queries in Server Connect also, but it is quite complicated. You can check my explanation, how to achieve it in the following topic:

www.dmxzone.com/support/23295/topic/61944

Thanks Teodor.

I've now read through the post and I think I see what it's trying to do.

I'm using two tables so I should be able to just do what you suggest as follows:

"
- categories query (uncheck output option)
- repeat categories query (select the output fields here, which you want to show later on the page); Enable output option.
- (inside the repeat) products query filtered by category ID.
"

One question though, how do I do the second point above and create a repeat step just using Server Connect? I can do it with App Connect but that requires something on the page to repeat.

If you can let me know or point me at a video showing how to repeat without App Connect I'd be most grateful.

thanks
Bruce

Hi Bruce,
Please check the following video: www.dmxzone.com/go/32997/nesting-database-queries

Thanks Teodor. That's perfect, just what I needed