group by tenant

Hi Tuto, I need to show on my table a group by tenant. this group will be applied for the userResource. If i have one tenant assigned to each user the group works well. However if an user belongs to two or more tenants , i get an error. SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row. Any help is appreciated. thanks
2 Replies
tuto1902
tuto19026mo ago
I believe this is a limitation on how grouping works. Meaning that, if you want to group rows, all records should belong to only one group. Therefore, I don't think grouping will work on this case. I would suggest just showing the tenants the user belongs to as a badge column.
RT2023
RT20236mo ago
thanks Tuto. that is what I thought