Access groups constraints with additional data stores

Support
#1

Hi,

I have a cuba application with 2 data stores (Main and Aditional)

I wan to create an access grou constraint that limit accesss for entities from the Main data store on criteria from the Aditional

So the constraint is on an entity called app$Order

and the constraint where clause is:

{E}.person.extId in (select m.id from app$TMperson m where m.pool.id = 3)

The error that we get when testing the constraint is:
The abstract schema type ‘app$TMperson’ is unknown.

We are using Cuba platform 6.8.13

#2

Hi,

Unfortunately, it’s impossible. Database-level constraints are applied to the query executed in a single database. You can try using a Groovy-based constraint checked in memory but be careful as it may affect the performance badly.

Regards,
Konstantin