Section Access- Hierarchy Level Following RSM, AMS & SUPERVISOR

[Sunil645454]

Hi Community,

Please find the below script and  where all users can only see their own data only however I want  like below

Explanation of Script:

1. ADMIN Access: The ADMIN role (e.g., rohit.saktel@demo.ai) has unrestricted access to all data using the * wildcard.
2. ASM Access:
   • Users like sunil.kumar@demo.ai and nikhil.thakur@demo.ai can see their data and all supervisors reporting under them.
3. Supervisor Access:
   • Supervisors (M002, M005, M006, etc.) can only see their own records

Data:

Section Access:- 

My_Table:

Please advise, Thanks

[Bhushan_Mahajan]

@Sunil645454 Refer below script where MID is ManagerID, PID as ParentID.

ABC:
load * inline [
MID, PID, Sale,Email
1,,20,A
3,1,30,B
4,1,40,C
2,3,40,D
5,3,50,E
12,4,60,F
13,4,10,G
];

VED:
Load MID as PID, Email as Email_PID Resident ABC;

right join

XYZ:
Load distinct PID Resident ABC;

left Join(ABC)
load * Resident VED; Drop table VED;

Section Access;
Load 'USER' as ACCESS,
Email_PID as USER.EMAIL,
Email
resident ABC;
Concatenate

Load 'USER' as ACCESS,
Email as USER.EMAIL,
Email
resident ABC;
Section Application;