Section Access

[neerajthakur]

Hi,

I want to apply restriction based on following logic:

REF_ID	Type	Region
1	Central	A
2	Central	B
3	Central	C
4	State
5	X
6	Y

I want to show user data of their own region and one user to have all the data. But applying section access I get data of only Type - Central and rest is lost for user of all data. Region is null for Type other than Central. How can I correct this?

[Mark_Little]

HI,

Can you share how you apply the section access? it is possible to set it up are you are explaining.

[neerajthakur]

Section Access;

ACCESSTABLE:
Load * Inline [
ACCESS,USERID,REGION_NAME
ADMIN,ADMIN_1,*
USER,USER_1,*
USER,USER_2,*
USER,USER_3,A
USER,USER_4,B
USER,USER_5,C
];

Section Application;

[agigliotti]

Hi @neerajthakur ,

You could achieve it with the below script:

Section Access;

ACCESSTABLE:
Load * Inline [
ACCESS,USERID
ADMIN,ADMIN_1
USER,USER_1
USER,USER_2
USER,USER_3
USER,USER_4
USER,USER_5
];

Section Application;
Star is '*';

ReductionTable:
Load * Inline [
USERID,REGION_NAME
ADMIN_1,*
USER_1,*
USER_2,*
USER_3,A
USER_4,B
USER_5,C
];

Star is;

I hope it can helps.

Best Regards

[neerajthakur]

Hi @agigliotti 

I tried it but it's not working as expected, it is working as normal section access applied earlier I am only getting Type - Central for Users with Full Access Too.

@MK_QSL @swuehl Can you help on this?

[MayilVahanan]

HI

Section Access is based on "Region", if there is no values [Null], then it won't display.

Instead of that, you can create the composite key [Type & Region] and use in the section Access. For Null values,  you can replace with some values like NA , so that, its easy for validate. 

[agigliotti]

Hi @neerajthakur ,

Could you share a sample app with mock data?

In that way will be easer to find out the issue.

Best Regards