topic Re: Section Access Property in QlikView

Section Access Property

villegasi03 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Section Access Property

adamdavi3s — Thu, 02 Mar 2017 07:40:44 GMT

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

Re: Section Access Property

Miguel_Angel_Baeyens — Thu, 02 Mar 2017 08:28:04 GMT

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.

Re: Section Access Property

adamdavi3s — Thu, 02 Mar 2017 08:30:43 GMT

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

Re: Section Access Property

Miguel_Angel_Baeyens — Thu, 02 Mar 2017 08:32:38 GMT

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.

Re: Section Access Property

villegasi03 — Thu, 02 Mar 2017 13:38:20 GMT

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

Re: Section Access Property

villegasi03 — Thu, 02 Mar 2017 13:40:01 GMT

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.

Re: Section Access Property

villegasi03 — Thu, 02 Mar 2017 13:44:33 GMT

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.

Re: Section Access Property

adamdavi3s — Thu, 02 Mar 2017 13:52:28 GMT

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

Re: Section Access Property

Peter_Cammaert — Thu, 02 Mar 2017 13:56:06 GMT

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.

Re: Section Access Property

adamdavi3s — Thu, 02 Mar 2017 13:56:33 GMT

Yes I can confirm that it is those two

Re: Section Access Property

adamdavi3s — Thu, 02 Mar 2017 14:03:10 GMT

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

Re: Section Access Property

Peter_Cammaert — Thu, 02 Mar 2017 14:03:24 GMT

Now that I think about it: this is never a fail-safe approach. I can easily forget to enable these two checkboxes (Data Reduction & Strict Exclusion), and decide to distribute my document without a reload to all Authorized Users (Publisher only). Worst case everyone gets to see all data that was already present in my document.

Maybe you're trying to implement a partial technical fix for something that is already wrong in the publishing process...

Re: Section Access Property

villegasi03 — Thu, 02 Mar 2017 14:06:51 GMT

This is exactly where I was going! Part of our reloading and environment promotion process involves the use of prj folders so this will work perfect! It will just have to be part of our best practices to include this check in any application requiring data reduction. Thank you very much for everyone's assistance!

Re: Section Access Property

adamdavi3s — Thu, 02 Mar 2017 14:07:12 GMT

If you read these properties in via XML then you could abort the reload if either are not set to true (if that is what you want)

Re: Section Access Property

adamdavi3s — Thu, 02 Mar 2017 14:08:19 GMT

No worries, the ONLY caveat I have thought of is that obviously this file won't get updated until the document is saved so as long as you

change >save> reload

and not

change > reload > save

you'll be fine!

Re: Section Access Property

Peter_Cammaert — Thu, 02 Mar 2017 14:13:54 GMT

The same properties that Adam posted a couple of minutes ago, are also available through the API. Meaning that you can write a macro function (not a sub) the returns the current Data reduction state, and call it in a dummy LOAD statement.

The properties are:

ActiveDocument.GetPtoperties.DynamicReduceData (true or fales), &

ActiveDocument.GetPtoperties.StrictDynamicReduction (true or false)

Based on these booelan values, we can make the function (let's call it GetReducitonProperties) return a value between 0 and 2 (0=No Data Reduction, 1=Data Reduction, no Strict Exclusion, 2 = Data Reduction and Strict Exclusion) and call it in a script like this :

TmpTable:

LOAD GetReductionProperties() AS ReductionProperties AUTOGENERATE 1;

Should work. Untested however.

Re: Section Access Property

villegasi03 — Thu, 02 Mar 2017 14:16:21 GMT

This is perfect!! Some of our enviornments do not allow for applications to have macros but for those that allow it this is certainly a great option. Thank you again for your assistance.

Re: Section Access Property

villegasi03 — Thu, 02 Mar 2017 14:17:43 GMT

Most certainly. Understood. I am almost 100% that in our current process we must pass through these steps before applications are moved up. Thank you again for the information.

Re: Section Access Property

Peter_Cammaert — Thu, 02 Mar 2017 14:20:17 GMT

These are not user-visible macros, but server-side only macros. Moreover, they will not be used by QVS (the QlikView server service), only by QVB.exe (the reload engine). No need to tell anyone.