Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
matthewp
Creator III
Creator III

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

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

5 Replies
marcus_sommer

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

matthewp
Creator III
Creator III
Author

Hi marcus,

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

Miguel_Angel_Baeyens

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

matthewp
Creator III
Creator III
Author

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

marcus_sommer

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