Database lookup fields in MR and OTS

Database lookup fields, or DBLookup fields, in the MR and OTS edit screens do not support the standard primary and secondary input fields method used to access data from other fields. Instead, certain DBLookup fields in these screens have a set of parameters available to them to allow them to connect to specific field values. A Parameters button is displayed next to fields with available parameters when the MR and OTS edit screens are open in Config mode. This button can be clicked to view the list of available parameters for the field. These parameters are referenced using the format #control.parameterName# when configuring the Field Parameters for a field.

For example, the Department labor metric field for rows in an MR or OTS can be configured to filter department names that match the UDF1 field value configured for the row. The Field Parameters would look like this:

sourceType=SQL source='SELECT DEPT_ID,DEPT_NAME,DEPT_DESC FROM DEPARTMENT where DEPT_NAME=?' 
orderBy='DEPT_NAME' 
sourceKeyField='DEPT_ID' 
sourceLabelField='DEPT_NAME' 
sourceParams='STRING==#control.udf1#'
labelFieldStatus=edit title='LOOKUP_DEPARTMENT'

See "DBLookups" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide for more details.