topic SQL Section access only working for NTNAME and ACCESS, NOT invoice number in QlikView

SQL Section access only working for NTNAME and ACCESS, NOT invoice number

matthewp — Fri, 25 May 2018 10:29:35 GMT

Below is my section access code:

SECTION ACCESS;

LOAD UPPER(ACCESS) as [ACCESS],

UPPER(NTNAME) as [NTNAME],

NUM(INVOICENO) as [INVOICE_NO];

SQL SELECT *

FROM qvdb.dbo.GPLSI_SA;

SECTION APPLICATION;

it works for the NTNAME part but when i specify an invoice number it doesnt apply this when the qvw is reloaded and i can see all invoice numbers not the one i specified in the SQL database

Re: SQL Section access only working for NTNAME and ACCESS, NOT invoice number

marcus_sommer — Fri, 25 May 2018 13:17:00 GMT

The restrictions of section access are applied by opening an application - each reload will load all data and needs to be prevented with the security settings within the document properties.

- Marcus

Re: SQL Section access only working for NTNAME and ACCESS, NOT invoice number

matthewp — Fri, 25 May 2018 13:45:11 GMT

Hi marcus,

can you explain what is going wrong with my SA then? Its in the front end file

Re: SQL Section access only working for NTNAME and ACCESS, NOT invoice number

Miguel_Angel_Baeyens — Fri, 25 May 2018 13:50:12 GMT

Are the document properties set to Reduce Data based on section access and Strict Exclusion? Be careful with the latest though, or you can be locked out of your own application if you have no data and you are not ADMIN

Re: SQL Section access only working for NTNAME and ACCESS, NOT invoice number

matthewp — Fri, 25 May 2018 13:53:13 GMT

Both Initial data reduction based on section access AND strict exclusion are both already ticked

Re: SQL Section access only working for NTNAME and ACCESS, NOT invoice number

marcus_sommer — Fri, 25 May 2018 14:20:15 GMT

So the document settings for section access are enabled and after opening the application no data-reduction happens for users which shouldn't see all data? In this case check if your reduction field from the section access is the same as in your section application (fieldname + content) because there need to be a connection between them.

- Marcus