Having had some questions in coaching sessions about the Group by feature, I decided to write an article about it. While the feature is fairly straightforward on its own, it does cause some confusion as to what exactly it’s used for. Hopefully this article can clear up some misunderstandings.
Thanks @petter for putting this article together and sharing.
I had realised that is how grouping works, but what is the solution if we need grouping in the way that you have told it doesn’t work?
So to continue your example if I want to build a table that shows nested repeating groups in it like I want to see the clients in different cities grouped by their cities. So basically I would have Cities as the row labels and then within each city, there would be another repeating group showing clients of those cities. I do not want to do the aggregation and calculation, I just want to show them like that.
Is there a way to do that using something like “group by” which would be faster or we have to resort to having to create multiple nested repeating groups?
In this case you’ll most likely have to create nested repeating groups. If your UX allows for it, you may want to make them expandable, so as to not load and render all rows at once but let the User decide when to expand each list of Clients.
You can also consider using an elementer like List Shifter to pre-load the list one each city row.
Very doubtful but why don’t you send a screenshot of the following and we can check for you:
your privacy rule for that data type
the relevant user data that’s referenced in the privacy rule
the group by search in the expression composer
It might ignore privacy rules in the calculation of an aggregation (I don’t know, but it’s a possibility) but it will never allow you to return data from individual things that you shouldn’t have access to.
@georgecollier
If I uncheck the “Find this in search” on the editor to Everyone else user, the repeating group returns nothing, but like in my case, the clumn of “name” can be seen to everyone
Sorry if this isn’t the answer you’re looking for, but can’t you just add the relevant search constraints (ones that match the privacy rule that you want to work?).