Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I seem to be having a problem filtering my data based on access.
The example I have is where lets say I login with an SID of AB1029.
This should filter and return roughly 6000 CLIENT_ID.. however I seem to be getting around 40,000.
I'm not sure where my problem is and I was wondering if my section access code's logic is correct.
section access;
star is *;
LOAD 'ADMIN' as [ACCESS],
'*' AS NTNAME,
SID as [USERID],
'*' as [PASSWORD],
'*' as SERIAL,
CLIENT_ID
FROM $(QVD_FOLDER)userINFO.qvd (qvd) where 1=1;
userINFO has two columns.
SID and CLIENT_ID
An associated SID has a set amount of client_IDS.
NOTE:
This is the other data I'm as well loading.
Section application;
Directory;
LOAD
CLIENT_ID,
CLIENT_NAME,
Date(MEETING_DATE,'MM/DD/YYYY') as CALENDAR_DATE,
MEETING_IDENTIFCATION
FROM
QVD\Info.qvd
(qvd)
AFAIR, no data reduction for ADMIN access...
Try a USER access (after making a backup of your file...)
hmm, gives me same results. I think I had roughly 20k when it's not filtered (without section access). When I log on to any particular user, it seems to only be giving me 14k (With user or admin). This number is way too big however. Is my logic above correct (for filtering client_ids)
How do the CLIENT_ID values look like?
I think they need to be all upper case.
In addition to Steven...
No matter how the values look like, use upper() in both section access and section application. I recommend to use upper for all section access fields.
Next - did you check "data reduction based on section access" in the document properties?
Regards,
Michael