I have 3 tables with the following relationship:
Tables:
Candidate
Project
PersonInCharge
Relationship:
1 Candidate can invovle in 1 and only 1 Project
1 Project can have multiple PersonInCharge
Each PeronInCharge have its own email which I wish to use it to create security filters.
When a PersonInCharge is using my app, I wish to add a security filter to the Candidate table so that it only shows Candidate in which its Project's PersonInCharge is the current user.
I have tried IN(USEREMAIL(), [Project].[PersonInCharge])but it does not perform the filter.
The way I setup my PersonInCharge column in Project Table is as follows:
Type: EnumList
BaseType: Ref
ReferenceTable: PersonInCharge
Data IF_VALID: PersonInCharge[Email]
What am I doing wrong?
LinkedIn
Twitter
