Sorting Repeating Group on Child Fields

Need help App Organization
1

Hi Bubblers,

I’m trying to sort some data and i really need some help. It seems others have had similar issues but i’m not able to decipher the solutions and apply to my case.

My database is setup as such:

Product
Product_ID
Category

Order
Order_ID

Order_Item
Product_ID
Order_ID

I’m trying to display a list of Order_Items. The list needs to be sorted by Product Category. It seems simple but the hacks I’ve tried of nested repeating groups havn’t worked, and the only reasonable way I can see to do it doesn’t work:

Screenshot 2023-04-23 at 20.49.56
Screenshot 2023-04-23 at 20.49.561398×1864 211 KB

Any clues?

2

2 ways…

  1. Add a sort field (number) to the Order Item datatype (based on the Product Category).

or

  1. Use the list shifter plugin to create a list (based on the Product Categories) to sort the list of Order Items by.
3

Thanks! did a youtube search on list shifter and found exactly what I need.

1 Like