HTML5 Data Bindings Support Product Page


Nested repeat region from database

Asked 23 Feb 2015 04:43:08
has this question
23 Feb 2015 04:43:08 Jeff Powell posted:
I have reviewed the tutorial on nested repeat regions, but you never showed how to set up the database. I have a MySQL category table (ID, CatName) and a detail table (ID, CatID, DetailName). In your example of motorcycles and colors, how do I set up the data source so that the nested repeat is properly filtered within the category repeat region?


Replied 23 Feb 2015 09:14:20
23 Feb 2015 09:14:20 Teodor Kuduschiev replied:
Replied 11 Mar 2016 10:28:10
11 Mar 2016 10:28:10 Dik Hendriks replied:
I am setting up a page with a list containing a repeat- and nested repeat region.
With the help of the tutorial this works fine, except for the sort-order i specified in the server connect action.
Is there a way to control the sort order?
Replied 14 Mar 2016 09:51:26
14 Mar 2016 09:51:26 Dik Hendriks replied:
I found a 'work around' for this issue;
Two seperate server actions, i use a main repeat region, inside this region i a placed a second repeat region whitch i filtered with a 'where ( id == $ )'. Now i can control the order on both server actions.
Replied 14 Mar 2016 10:10:28
14 Mar 2016 10:10:28 Teodor Kuduschiev replied:
Hi all,
With the new server connect you can created nested database queries, in a single server action file. I will setup a tutorial about this later this week!

Reply to this topic