DMXzone App Connect Support Product Page


How do I create nested repeats?

Asked 09 Aug 2017 13:46:21
has this question
09 Aug 2017 13:46:21 Bruce Wilkie posted:
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.


Replied 09 Aug 2017 14:30:11
09 Aug 2017 14:30:11 Teodor Kuduschiev replied:
Hi Bruce,
So you want to nest them on the server side or?

Please check this video - using the App Connect Formatter: you can achieve this.
Replied 10 Aug 2017 08:43:08
10 Aug 2017 08:43:08 Bruce Wilkie replied:
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?

Replied 10 Aug 2017 08:51:53
10 Aug 2017 08:51:53 Teodor Kuduschiev replied:
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:
Replied 31 Aug 2017 13:37:57
31 Aug 2017 13:37:57 Bruce Wilkie replied:
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.

Replied 31 Aug 2017 14:09:14
31 Aug 2017 14:09:14 Teodor Kuduschiev replied:
Hi Bruce,
Please check the following video:
Replied 04 Sep 2017 13:24:28
04 Sep 2017 13:24:28 Bruce Wilkie replied:
Thanks Teodor. That's perfect, just what I needed

Reply to this topic