Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Getting very stuck on section access, so hoping someone can tell me where I'm going wrong!
Our clients log into their applications via QV Accesspoint, and can only see the documents that they have access to.
I would like to limit the data they see once they've logged in - I managed to get this working properly on an old document so I know it's possible, but can't recreate it (and no longer have access to old doc).
Basically, there is a field in the data called 'NAME' and our users login using their 'NAME'. I want the field 'NAME' to be filtered according to what they login as.
At the moment, in the script I have:
Section Access;
LOAD * inline [
ACCESS, USERID, NAME
USER, jessica.webb,*
USER, Super,*
USER, George,George
USER, Sam,Sam
USER, Dennis,Dennis
USER, Mark,Mark
USER, INTERNAL\SA_SCHEDULER,*
];
Section Application;
If I logon (jessica.webb) or 'Super', I would like us to be able to see everything with no data reduction. But if George logs on, he should only see data associated with 'George' in the name field.
At the moment, this isn't even slightly working. If I logon as 'George' via access point, it asks me to reenter username and password again when I click to open the document (I don't want our users to have to login twice), and then I can see everything anyway - i.e. the data reduction hasn't worked!
Help with this would be greatly appreciated,
Jess
Hi Mahesh,
Thanks for the link. Unfortunately it seems to be solving a different problem to mine. I would like data reduction, not sheet access...
It also doesn't solve the problem of avoiding users having to login twice.
Thanks,
Jess
Hi
Have a look:
Hope it helps!!
Think that NAME-field has to carry capitals only.
Peter