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

[matthewp]

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

[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]

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]

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