Section Access with multiple fields Or condition

[vardhancse]

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

[#2]

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

[vardhancse]

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

[vardhancse]

USER NAME AND PASSWORD PLEASE.?

[vardhancse]

Hi,

My requirement is not based on region and more over looking for solution with or condition between 2 fields

[vardhancse]

I am looking for or condition between GRM and LRM but not on country

[jagan]

Hi Sasi,

Is there any sample user details with sample LRM & GRM values?  Please attach.

Regards,

jagan.

[vardhancse]

Hi Jagan,

PFA QVW for reference.

[#9]

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

[jagan]

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.