Forum Discussion
Dynamic Slicer based on user Role/Email
Hi,
Thanks for providing such usefull tips. RLS seems to be a case to solve my issue partly. I am struggling with Path() function, because in my org structure a single employee can have 2 different managers. It breaks everything and i cant get over it.
Table 1
| Manager | Emp |
| M2 | E1 |
| M2 | E2 |
| M3 | E2 |
| M3 | E3 |
| M1 | M2 |
| M1 | M3 |
Table 2
| Emp | Ticket ID |
| E1 | 111 |
| E1 | 222 |
| E2 | 333 |
| E2 | 444 |
| E3 | 555 |
I want M1 to see all ticketing data, M2 to see E1 and E2 Tickets, and M3 to see E2 and E3 tickets. Is there a way to build path that leads to 2 different managers?
As always any tips are appreciated.
Best Regards
Hello @ksusser,
There are two ways to see it, one of the tickets to parents and grandparents (in this case would be to look for the entire path in Table1 with PATH(Emp, Director), although it would be necessary to add the M1 without grandfather), or vice versa, that each user had all the employees who depend on it (that is, that you would have to create a new table1 with the missing data of the grandparents and their grandchildren).
Best regards!
If you have the message, please consider accepting it as a solution. Welcome the kudos!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.