Hi all,
I got a request to allow user not only to view own data, but also their belonging team data.
Attachment is my mock up data model and I had setup a dynamic security role, however, I must use the bidirectional realtionship to fulfill this request.
- Apply role to Team_Profile, then bidirectional filter to Team_Manager table
- Team_Manger table to filter the account profile
Although it is working, any recommendation to avoid that bidirectional relationship and static role?
cos, I got so many team and user in the real model. It is hard to setup static role
Thanks a lot!