Advanced LSF security getDBField

m-christoflour

I'm trying to create a rule using the getDBField and need some assistance.

Basically, I'm trying to limit time entry on PR35.1 for a user to have access to enter time for individuals in a certain process level.  Problem is... that form doesn't allow this.  So, I'm guessing I can use the getDBField to be able to do this.

Soo.. the security class I want to create will only have this form on it.  The logic will be something like this...

If the employee (whose time is being entered) is in Process Level xxx, then All Access

Else No Access

 

I'm guessing we can go through the form.TRD_EMPLOYEE field to get the correct employee and tie that somehow to the Process Level this employee is tied to.  We don't want to use the Job Code because there could more added later and we want to limit maintenance on the security class.

Any help would be greatly appreciated!

 

-Brad

unknown

Here's an example of what we did for the clock_nbr field on the paemployee table and the BN32 form. You would enter that into the expression builder and then select all access and no access...you probably would do 'EMPLOYEE' and 'PROCESS-LEVEL' and then use the form company and employee values equal to the process level you want...



getDBField('PAEMPLOYEE','CLOCK-NBR',form.BEN_COMPANY,form.BEN_EMPLOYEE)==30