Repeating group: show group header records

Need help App Organization
1

Hi there,

I have the following data structure:

  • Categories have many
  • Series have many Products

I want to show the products in a repeating group as follows:

Row: Category.Title
Row: Series.Title - Product.Number:Product.Title
Row: Series.Title - Product.Number:Product.Title
Row: Series.Title - Product.Number:Product.Title

Preferably I want to sort the products on Series Title and Product Number.

What is the best approach:

  1. Create an RG based on Category. Use a group element to display Category and in there a RG for listing Products associated with each category. Or
  2. Create an RG based on Products, use a :grouped_by filter and display category details in a Group element only to show on the first index of each grouped set of records
  3. Other…

Thanks!

2

I think number 1 may be. You can check out this basically example for folders/files