The adding of an exercise solution certainly solves the issue and is something I’ve already implemented, but the displaying of the Group workout doesn’t solve the problem.
If I do a search for those clients workouts and display them in a RG, it will display all of the clients workouts and exercises. I need the RG to only display the workouts and exercises within those workouts (which are contained within another RG inside the workout RG) that are common amongst all clients. Adding :unique elements to the search doesn’t work as it removes the duplicates but shows the workouts/exercises even if theres only one instance of them.
:intersect with could work if I had a fixed number of clients per group by doing: Search for workouts:first item:intersect with Search for workouts:item #2:intersect with… etc. But since theres no fixed number this wouldn’t work (as far as I can tell) because if for example theres 9 Clients in the group and the expression goes up to 10, the expression would return nothing as the 10th item has zero entries and therefore items 1-10 have zero entries in common.
This is why I thought a data structure solution would be fit for this problem as I couldn’t figure the above issue out. It’s been doing my head in as its a critical part of my app.
Again, thanks for your patience 