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

[hariprasadqv]

Hi,

In that case LRM and GRM names should be different.It is better to use ID's.

Thanks.

[vardhancse]

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

[vardhancse]

gwassenaar‌ jagan‌ Can please help me out

[#5]

Hi,

first of all you will use upper case of fields, because section access will work only on upper case values.

Regards

Vimlesh

[vardhancse]

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

[#7]

Try this

Hope it helps

[#8]

hi,

look at this app.

username -  ram

password-  ram

Regards

Vimlesh

[#9]

Hi,

Why dont you load one table with user and  countries he has access to.PFA

ADMIN1,ADMIN1

USER1,USER1

[hariprasadqv]

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