Hi all! I have a big doubt, I hope you can help me.
I'm interested to use my Java+Struts+Spring+EclipseLink application with multitenancy, I did some examples to provide multitenancy and everthing was ok.
I have a weird requirement that could be possible this situation:
* Tenants A,B,C with isolated data and shared schema and using single table.
* Tenant A and B can see also data from Tenant C. But Tenant C can see just its own data as multitenancy works normally.
A real example could be a company with differents deparments using my application but some departments can see other data.
For insert data I think I can manage my code with @Multitenant(MultitenantType.SINGLE_TABLE) but I dont't know if the part of filter data is possible to be managed with eclipseLink or what solution I can use.