Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
michael_maeuser
Partner Ambassador
Partner Ambassador

Section Access "Star"

Hi,

is it possible that section access works differently, depending if I load the data inline or from a sql database?

Example 1:

Section Access;

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME, LINKFIELD

    ADMIN, DOMAIN\User1, *

    ADMIN, DOMAIN\User1, 1

    ADMIN, DOMAIN\User2, *

    USER, DOMAIN\User3, 2

];

Section Application;

STAR is *;

SecLink:

LOAD * Inline [

LINKFIELD, Company

1, company1

2,company2

];

This example works fine now, but I thought that the second line from the section access table is not necessary since User1 has a star. But without that line it doesn´t work anymore. I must have all each value loaded at least once in the section table, otherwise even the useres with * don´t see all companies.  What I think is strange, is that I also have another example where I load the section access table from a sql database. In this case it´s enough if the database table looks like that:

ACCESS, NTNAME, LINKFIELD

    ADMIN, DOMAIN\User1, *

   ADMIN, DOMAIN\User2, *

    USER, DOMAIN\User3, 2

User 1 and User 2 see both companies. If I change my inline load from the first table, so that it looks like that, user1 and user2 will also only see company 2

17 Replies
michael_maeuser
Partner Ambassador
Partner Ambassador
Author

yes i checked that box

michael_maeuser
Partner Ambassador
Partner Ambassador
Author

i have that documet and i also load everything uppercase in my qvw (sorry forgot it above).

like i wrote, my section access example works now.

the only thing what i don´t understand is, that user with * sees everything (not only listed) if i have my permission data in a database.

e.g. table in db:

User 1,  *

User 2, company2

user 1 sees company 1 and 2. so it is another behaviour compared to inline load. that´s what i can´t understand

michael_maeuser
Partner Ambassador
Partner Ambassador
Author

a little late but now i got it why you asked for that sure in my case i shouldn´t activate strict exclusion

jjordaan
Partner - Specialist
Partner - Specialist

Is it possible to share your file?

agigliotti
Partner - Champion
Partner - Champion

I'm using EMPTY string (ex '') in section access but with STRICT EXCLUSION checked I can't open the document anymore.

agigliotti
Partner - Champion
Partner - Champion

"STAR IS" means all values but NULL is not included !

vivek_kalekar
Partner - Contributor II
Partner - Contributor II

Yes.exactly...but what needs to be done if i want to see those null values? I am facing a similar problem where 'STAR IS' is used and i can see all the values but not the null !

agigliotti
Partner - Champion
Partner - Champion

the only way to see null values is replacing those with a string.