Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Section Access Property

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

1 Solution

Accepted Solutions
Highlighted
Master
Master

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]);

Capture.PNG

View solution in original post

21 Replies
Highlighted
Master
Master

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

Highlighted

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.

Highlighted
Master
Master

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

Highlighted

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.

Highlighted
Creator
Creator

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

Highlighted
Creator
Creator

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.

Highlighted
Creator
Creator

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.

Highlighted
Master
Master

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

Capture2.PNG

Capture.PNG

Highlighted

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.