01 May 2014 18:07:25 Steve Skinner posted:
Using one of my customer sites, I've built a test page that shows orders, but for the life of me I cannot figure out how to show the items for each order. I know this deals with parent children repeat regions but I cannot figure it out. Your video demos use custom JSON files instead of real database tables, so I cannot use your information to compare to my own. In that respect, the video demos regarding repeat regions and repeat children are not very helpful. Most data driven sites have real databases, not custom JSON files as in your examples.
I have two database tables:
- orders (contains shipping, billing, order summary information)
- order items (contains the items that are on each order
I have tried creating joins, but all that has done for me is given me a list of orders where each order ID is repeated for every item on the order.
My test page has a repeat region for the order list on the left, and a detail region on the right, which shows order information for each order when you click it on the left.
*** I need a repeat region inside my detail region which shows the items for the order, and that information comes from the orderItems table, and is related based on the OrderID.
My problem is partially not understanding how to set data connections so that this will work correctly. Someone following your video tutorials would be lead to believe that everything has to be all part of one data connection, but I have had no luck with that.
I have referenced the video for the HTML5 Formatter on Grouping, but that does not work for me because I need the repeat children region for order items to appear in the detail region, and not with the repeat region used for the order list, which is how your video tutorial instructs.
I have emailed my live test page to Teodor, since it is not something I want to be public, in that it deals with customer order information.