Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Have a requirement is that
Have below data
Group | Country | GRM | Customer | Location | LRM |
Group1 | India | Name1 | Customer1 | India | Name1 |
Group1 | India | Name1 | Customer2 | Singapore | Name2 |
Group1 | India | Name1 | Customer3 | Australia | Name3 |
Group1 | India | Name1 | Customer4 | China | Name4 |
Group2 | Australia | Name3 | Customer1 | Singapore | Name2 |
Group2 | Australia | Name3 | Customer2 | Australia | Name3 |
Group2 | Australia | Name3 | Customer3 | China | Name4 |
Group2 | Australia | Name3 | Customer4 | India | Name1 |
Now my section access should work like if a user login in to dashboard, he should be either GRM/LRM then then only he should see his relevant data.
Can please any one let me know the solution for the same, thanks in advance for your support.
PFA sample QVW
Hi,
In that case LRM and GRM names should be different.It is better to use ID's.
Thanks.
Hi,
The condition is that the login user to dashboard should see the data only for which he is either GRM & LRM, that is why we should have or condition
gwassenaar jagan Can please help me out
Hi,
first of all you will use upper case of fields, because section access will work only on upper case values.
Regards
Vimlesh
Hi thanks for your reply,
Yeah I know section access will work on upper case I tried merging both GRM and LRM using the condition like
UPPER(IF(len(trim(GRM))>0,GRM,'<ANY>') &'|'& IF(len(trim(LRM))>0,LRM,'<ANY>')) as AuthID
in fact table
Try this
Hope it helps
hi,
look at this app.
username - ram
password- ram
Regards
Vimlesh
Hi,
Why dont you load one table with user and countries he has access to.PFA
ADMIN1,ADMIN1
USER1,USER1
Hi,
1.As vimlesh20 said SECTION ACCESS elements shoud be in UPPER CASE.
2.Regarding your case. Either LRM or GRM they should be identified by a key value right, so use that key ion the section access tabel.
3.In the mapping tabel map the keys with their Role(GRM/LRM)
See the below prototype. It may help you
Ex:
Section Access Table:
USERID PASSWORD EMPID
A 1234 101
B 1234 102
C 1234 103
D 1234 104
E 1234 105
MAPPING TABLE:
EMPID POSITION LOCATION
101 GRM INDIA
102 LRM US
103 LRM UK
104 GRM UAE
105 LRM INDIA
Thanks