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,
yes you can use
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, AUTHID
ADMIN,ram,ram,NAME1|NAME1
ADMIN,vimlesh,NAME2|NAME1
ADMIN,san,san,NAME1|NAME2
];
Section Application;
table:
LOAD GROUP,
COUNTRY,
GRM,
upper(Customer) as CUSTOMER,
upper(Location) as LOCATION,
upper(LRM) as LRM,
UPPER(IF(len(trim(GRM))>0,GRM,'<ANY>') &'|'& IF(len(trim(LRM))>0,LRM,'<ANY>')) as AUTHID
FROM
(ooxml, embedded labels, table is Sheet1);
Regards
Vimlesh
Hi,
Yes but in for limited set of combinations we can use but of large volume of data how can we go in manual approach
USER NAME AND PASSWORD PLEASE.?
Hi,
My requirement is not based on region and more over looking for solution with or condition between 2 fields
I am looking for or condition between GRM and LRM but not on country
Hi Sasi,
Is there any sample user details with sample LRM & GRM values? Please attach.
Regards,
jagan.
Hi Jagan,
PFA QVW for reference.
Hi jagan,
My client need to authenticate through gmail account and then pass access.
please help me.
i searched and got web ticking ,when i am using that code ,getting some error.
please tell me something how can i do.
Regards
Vimlesh
Hi,
Try like this using OMIT
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN,ADMIN1,ADMIN1, LRM
USER,USER1,USER1, GRM
USER,USER2,USER2, GRM
];
Section Application;
Now user ADMIN1, LRM column is hidden
Now user USER1, GRM column is hidden
Now user USER2, GRM column is hidden
Please find attached file.
Regards,
Jagan.