Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In my application the section access part has been added by loading two fields Username and Password from the SQL database. That was running fine. But now there is a need to select a field value i.e. to apply a filter for a particular User.
I have added the trigger Select in Field for that particular field and the value as IF( QVUser()='A','apple') . But its not working.
It will be great if I can get some help on this.
Hi ,
can you please give more info on this
what my understanding here you applied section access after that once you deployed this in to the server if any user open this document t has to select his NT name in the list box is that my understanding correct?
when you enter osuser() in a textobject, what is the outcome?
in your example the domainis missing
osuser() Returns Domain\userA
Instead of using triggrs, it is better to use data reduction based on section access. See example from "help" where the DEPT field is used for data reduction:
section access;
load * inline
[UserID,DEPT,Access
John,FINANCE,Admin
ANN,IS,Admin
Peter,SALES,User
Ben,TECH,User ] ;
section application;
star is *;
load * inline
[DEPT,CostCenter
FINANCE,*
IS,5020
SALES,5030
TECH,5040 ] ;
This document has examples on setting up Section Access and data reduction. There is no need to use triggers.
Remember to create a safe copy of your document before applying section access controls as you can lock yourself out of your document permanently.
Instead of creating condition on front end, You can reduce the data in Sanction access itself.
You can create saction acccess metrics as below
Access, UserID, Password, Fruit
ADMIN, ADMIN, ADMIN, *
USER, JOHN, JOHN, APPLE
USER, MARY, MARY, APPLE
USER, PETER, PETER, ALL ];
See the below link