Section Access link table

Nolan — Thu, 26 May 2022 19:19:48 GMT

Good Afternoon,

I am trying to execute a very simple Section Access on an app and am running into the problem below:

I am able to limit my view down to one WhN #. So if I assign myself (ngavin) the KEY of '2' in the section access table and then load the app, I am only able to see data relative to WhN 513. However when I try to apply the KEY of '1' to myself to be able to see data from all WhN's the app creates an actual value in the field WhN of '*'

Wondering how to apply the * to include all values instead of creating it's own, thanks!

Re: Section Access link table

Raja2022 — Fri, 27 May 2022 00:56:23 GMT

One way of doing the way you want is as below:

section Access;
access:
LOAD * Inline [
ACCESS, USERID, KEY
USER,NGAVIN,*
USER,SYUAN,2
ADMIN,SCHEDULER,1
DUMMY,DUMMY,3
];

Section Application;

DataReduction:
Load * Inline [
KEY, WhN
1,500
2,513
3,514
];

Output:

Hope this helps...

topic Re: Section Access link table in App Development

Section Access link table

Re: Section Access link table