Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
We have a requirement.
We have a users table which contains fields like Users, Department & Product. when ever user opens application only his related Department and Product only should display.
We are also having 5 to 6 tables and all the tables have Department and Product field and we have developed data model according to the requirement.
So when ever user opens application only his related Department and Product should be display.
For example I am having
User Department Product
Mike Electronics Mobile
Laptop
CPU
Alex Automobile Bumper
Gear Rods
Bolts
If the User Mike login to application then he have to see related Department & Product values only.
This Department & Product values are not static. these are dynamic. in dev environment we will have different departments & Products. In Test environment we will have different Department & Products. We need to achieve dynamically.
Can some one help how to achieve this? or else can share any related article regarding this scenario
Thanks,
Satya
Hi Friends,
Is there any chance to achieve this ?
Hi,
You can use section access for data reduction based on the columns and data specified in Section Access table.
Thanks,
Ashutosh