Trouble implementing Section Access

[#1]

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.

[disqr_rm · Accepted solution]

Try converting USERID to Upper Case using upper() function.