RT2023
Explore posts from serverstable group by tenant
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
Multi-Tenant Page Approach
Hi everyone. I have an app with multi-tenancy and it is working well with all the resources in such panel. For one resource, I had to create a new filament page (not associated with the resource) to do some simple mathematical operations. Sum of total columns and division to calculate percentages. this works great as well. The issue I have is that I cant filter the calculations by tenant. It just add all the values in the table . Can someone provide any advise please?
14 replies