Hi all -
I'm having a bit of trouble getting Section Access to properly reduce the data on initial load. I have the "Initial Data Reduction Based on Section Access" box checked, and "Strict Exclusion" also checked. I'm using QV 9.0 and only opening the document on my local machine using a Developer License, not from the server. Here's what a portion of my code looks like:
section access;
LOAD * INLINE [
ACCESS, USERID
ADMIN, ADMIN
ADMIN, JohnDoe
USER, JaneDoe
];
section application;
[User Exclusion]:
SQL SELECT
E.EmployeeName [USERID],
E.employee_id
FROM
EMPLOYEES E;
If I attempt to open the QVW as JaneDoe, it won't allow me to open it, as expected, but if I open it as "JohnDoe," I can see information related to other Employees when I should only be able to information related to one.
