topic Re: Data filtered by user in App Development

Data filtered by user

asanfelix — Mon, 20 Dec 2021 21:32:42 GMT

Hello,

i have an app with lot of tables related to a master table with information about sales products.

Each product get assigned his brand.

I'd like that "USER01" can only see data about products of brand "BRAND01", and all the other users can see everything.

I have seen posts talking about Section Access, but i'm not able to know how to solve my problem using Section Access.

Is there any way to do this?

Thanks!

Re: Data filtered by user

Mauritz_SA — Wed, 04 Mar 2020 13:22:46 GMT

Hi @asanfelix

This post by @Dalton_Ruer is probably the best I've seen on the topic. I would recommend working through the PDF and getting an understanding of how section access works before implementing it, otherwise you'll just be guessing. I'm sure his example will help.

Regards,

Mauritz

Re: Data filtered by user

124rooski — Wed, 04 Mar 2020 14:14:51 GMT

section access is pretty simple - I'll take your example for using BRAND01. You want to figure out what your domain and user id is by going into your QMC. Essentially there are 2 parts. Section Access and Section Application. Under the Section Access, you can see I have 3 columns. You must always include the "ADMIN, INTERNAL\SA_SCHEDULER". I added yourself as an Admin since I'm assume you'd want to see all the data, but loaded a regular "user" for the user that should see only BRAND01. The "1" under the "user" line denotes that that user should only see data pertaining to BRAND01. I created a linkage through PRODUCTID as you can see in the script below. If you want to restrict other brands from other users, you can just sequentially add rows underneath the section application script with the the updated brands and add the respective productid number to the section access piece (part 1 of the Section Access). Hope this helps and sheds light. One last thing - make sure your data here is all uppercased.

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USER_ID, PRODUCTID
ADMIN, domain\*YOUR ID FOUND FROM QMC*, ,
USER, domain\*YOUR USER*, 1
ADMIN, INTERNAL\SA_SCHEDULER,*,
];

SECTION APPLICATION;

LOAD * INLINE [

PRODUCTID, PRODUCT

1, BRAND01

];