Section Access based on Island Table

[sumeet-vaidya]

Dear All,

Please help me in fixing a scenrio.I have my data model and an Island table used for selection in the frontend. I need to reduce the data based on Island field.

Kindly help.

stalwar1‌

Thanks & Regards

Sumeet

[big_dreams]

AFAIK, You can not reduce data using island table in script.

What is your goal? what are trying to achieve? can you explain with sample data??

Regards,

[sumeet-vaidya]

Hi Max,

The scenario is such that I have calling data.

Eg

User has contacted a XXX company from Call Centre 1 (Table 1)

XXX company called user back from  Call Centre 2.(Table 2)

Whenever I am showing my Report, Filter should be on both the data. like if i Select Call Centre = ABC,

Data should be filtered for Contacted as well as Called so I have created an island table concatenating values of Call Centre from both the tables and using below expression.

Count({<Call Centre 1 = P(Call_Centre_Final)>}  ID)

Regards

Sumeet

[arvind_patil]

Hi Sumeet ,

It works in My case like below

Section Access;

Load * Inline [

ACCESS, USERID, CITY

ADMIN , BA\PREDOOLE,SANGLI

ADMIN , BA\PREDOOLE1,PUNE

];

Section Application;

IslandData :

Load * Inline [

CITY

Mumbai

Pune

SANGLI];

Thanks,

Arvind Patil

[big_dreams]

bro it will reduce only island table. Not reduce entire document data.

Regards,

[sumeet-vaidya · Accepted solution]

Hi,

Got the Solution. Data will not be reduced but It will not show up in the frontend by using P().

Thanks all for helping around.

Regards

Sumeet

[sumeet-vaidya]

Hi Max,

You are correct. Data wont get reduced. Its just that we need to restrict user from accessing certain Call Centres which can be done with the help of P().

Regards

Sumeet

[big_dreams]

glad you got the answer,

Just for my understanding how did you use p()?

Regards,

[sumeet-vaidya]

Hi Max,

Just as I mentioned in my previous trails.

Count({<Call Centre 1 = P(Call_Centre_Final)>}  ID) ==> for Contacted

Count({<Call Centre 2 = P(Call_Centre_Final)>}  ID) ==> for Called

Call_Centre_Final column added in Section Access.

Regards

Sumeet

[big_dreams]

cool.