Solved: Re: Section Access Property - Qlik Community

villegasi03 · ‎2017-03-01

Is there a way to check that the section access properties are set on a QVW within the load script? If this is possible, I wanted to use this as an additional check before distribution

Thank you

adamdavi3s · ‎2017-03-02

So to answer fully, yes you can test the checkboxes.

You need to create the -prj folder

Creating prj Folder

Then read in the docproperties.xml

DocProperties:
LOAD
DynamicReduceData,
StrictDynamicReduction,
  InitialSelection,

    %Key_DocProperties_A4A6ED072BE66637    // Key for this table: DocProperties
FROM [.\test-prj\DocProperties.xml] (XmlSimple, Table is [DocProperties]);

View solution in original post

adamdavi3s · ‎2017-03-02

It might be possible if you create a -prj folder one of the properties xml files might have it in there which you could read in, but I am not 100% sure

Miguel_Angel_Baeyens · ‎2017-03-02

If the section access table is set in a the normal script, and not in the hidden script, then yes, you can see that just using the script editor and searching for section access.

If it is on the hidden script or it is a published application (which never has a script on it) there is no way of knowing whether section access is being used unless you try with headers or a different computer and you get this "Access denied" or a prompt for userid and password.

adamdavi3s · ‎2017-03-02

I was assuming it was the "checkbox" properties rather than the access tables

Miguel_Angel_Baeyens · ‎2017-03-02

Could well be, it stuck to the "within the load script" part. Still, you could use section access but not check for initial selection or exclusion based on section access values if you just want to protect who can open the file, but all users have access to the same set of data.

villegasi03 · ‎2017-03-02

Adam, Yes that is correct. I am specifically concerned with the "checkbox" properties.

villegasi03 · ‎2017-03-02

Miguel,

Exactly! This is what we are trying to avoid. I mean I can add user tables and go through all of the normal scripting to set this all up but at the end of the day if that box is not checked then there is a risk of exposing data.

villegasi03 · ‎2017-03-02

I assume that the application somewhere in the background checks for this parameter. I noticed in the log files certain parameters are already being checked since I can see that these are either set to a '1' or '0'. I am wondering if this maybe the same for this property checkbox but its just not showing in the log file.

adamdavi3s · ‎2017-03-02

Ok if you create a prj folder and get the docproperties.xml I am pretty sure it is these two:

Peter_Cammaert · ‎2017-03-02

Checking in your script for an upcoming data reduction (only applied after a reload, when the document is first opened) is probably tricky. Maybe this can be done by calling a macro function in a dummy LOAD statement.

In the end, this is a purely document-related property.