Forum Discussion
fcarvalho
Advocate I
Advocate IGet all Child record from all levels
Hi, I'm trying to create a Table to be used as RLS. The idea is to use my existing Parent and Id columns from Table A. Table A UserParent emailParent userIdParent Sub IdSub User...
fcarvalho , Have you already explored this blog?
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
I think I achieved what I wanted, I'll do some tests and then close the post
amitchandak
Super User
Super Userfcarvalho , Have you already explored this blog?
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
fcarvalhoHi amitchandak ,
It is a very good article, but it does not fit my case, because in my data set, a child level sometimes has 2 different parentId or more and I get the error that some value has multiple values.
Another situation is to have to add 1 column per level manually. If there is an alternative, I would appreciate it.
Regards,
Thank you