More than one table in Section Application ?

[Anonymous]

Hi,

In my application, I got this to limit visibility to my users:

Section Application;

Visibilite:

LOAD

    IDSALARIE, Hash128(ICCOUT1,ICCOUT2,ICCOUT3,ICCOUT4,ICCOUT5,ICCOUT6,ICCOUT7,ICCOUT8,ICCOUT9,ICCOUT10,ICCOUT11,ICCOUT12,ICCOUT13,ICCOUT14,ICCOUT15) as keyVisibilite;

SQL execute get_salaries_vcc $(vIdClient);

That's working fine for limiting data in my app.

Now I have a new request: limit sheet access by user.

So, I would like to add a field "SHEETACCESS" wich contains "SALESGROUP", "HRGROUP", etc. and control for each field if the user connected is in a group that have the right to see the sheet.

Could you please tell me the best way to have this result?

[IAMDV]

Hi,

I'd suggest building a string for all the user names in the script. Something like this...

User_01 | User_02 | User_03 | ....... | User_100

Then you can use OSUser() function to show or hide the sheet object based on the OSUser() name. Something like this...

Match(SubField(OSUser(), '\', 2), vUserNameString) > 0

I hope this helps!

Cheers,

DV