topic Re: Section Access- Hierarchy Level Following RSM, AMS & SUPERVISOR in App Development

Section Access- Hierarchy Level Following RSM, AMS & SUPERVISOR

Sunil645454 — Fri, 06 Dec 2024 12:27:12 GMT

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:

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

Data:

Section Access:-

My_Table:

Please advise, Thanks

Re: Section Access- Hierarchy Level Following RSM, AMS & SUPERVISOR

Bhushan_Mahajan — Tue, 14 Jan 2025 11:48:47 GMT

@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;