topic Re: Star is in App Development

Star is

ali_hijazi — Mon, 27 Jan 2025 09:59:38 GMT

Hello
long time I haven't used the STAR is
I'm trying to recall its usage now
correct me if I'm wrong

Section Access;

Securtity:
load * Inline [
ACCESS,USERID, REDUCTION_FIELD
USER, DOMAIN/USER1, <ANY>
USER, DOMAIN/USER2, A
USER, DOMAIN/USER2, B
USER, DOMAIN/USER2, C
];

Section Application;

FACT:
load * inlin [
REDUCTION_FIELD, DATE
A, JAN-2024
B, FEB-2024
C, MAR-2024
D, MAR-2024
...

];

Does this mean that USER1 seas data related to A,B,C, and D?
If not, then what is the approach to make USER1 see data to any value under the reduction field?

Re: Star is

Ben_P — Mon, 27 Jan 2025 10:00:41 GMT

STAR IS defines the wildcard used in section access.

So if you specify e.g. STAR IS %; then you can use the % character in your section access to mean 'all listed values'.

If you specify just STAR IS; with no character, that means that no wildcard character is applicable.

Star | QlikView Help

In your example, this would give USER1 access to A, B, C (but not D as it's not listed in the section access):

STAR IS *;

Section Access;

Security:
load * Inline [
ACCESS,USERID, REDUCTION_FIELD
USER, DOMAIN/USER1, *
USER, DOMAIN/USER2, A
USER, DOMAIN/USER2, B
USER, DOMAIN/USER2, C
];

... in order for USER1 to see D, you'd need to do something like adding a dummy permission so that D is listed, e.g. an extra line in the section access:

USER, DUMMY_USER, D

Re: Star is

ali_hijazi — Mon, 27 Jan 2025 09:57:44 GMT

you didn't answer my question
what do you mean by all listed values?

Re: Star is

Ben_P — Mon, 27 Jan 2025 10:02:49 GMT

All values that are listed in the section access. I've edited my post above to give an example.