Hi everyone,
I'm currently facing an issue with Data Model Security in Board and would appreciate some help.
I created a new Data Model and I want the security behavior to work exactly like in one of my existing models. In my existing model, data visibility is restricted successfully based on global User Meta variables. In the new Data Model, I only have 2 out of my 4 globally defined User Meta variables (Legal Entities & Product).
Here is what I already configured:
- I created the same Data Model Profiles under: Security & Auditing → Data Model Security. I used the same Access Mode and Security System settings as in the working model. There are no explicit SELECT restrictions on the Data Model itself.
- Under System Administration → Roles I already have the platform-global roles. I added the new Data Model under the Role configurations. In the Select section, I added the same custom selection script logic that works in the other model:
SELECT X = @var(X)
SELECT Y = @var(Y)
The problem is:
- When the selection script is active, I see no data at all from the new model.
- When I remove the selection, I can see all data across all entities.
So it looks like the User Meta variables are not being applied correctly to the new Data Model.
My question is:
Is there any additional configuration required so that global User Meta variables and custom selection scripts work with a newly created Data Model? Or did I miss any required step?
Any ideas or troubleshooting suggestions would be greatly appreciated.
Thanks!