Database lookup fields in Central Staffing
Database lookup fields, or DBLookup fields, in Central Staffing do not
support the standard master and slave 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 #control.parameterName#
when
configuring the Field
Parameters for a field.
This is useful for configuring fields that are used in Central Staffing
transactions multiple times on different rows. The field behavior depends on the field
values corresponding with the specified parameters on the same row. For example, you can
configure the Department labor
metric field in the Edit Shift pop-up to filter department names
that match the UDF1 field
value selected for the same work or on-call detail. 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'
labelFieldStatus=edit title='LOOKUP_DEPARTMENT'
sourceParams='STRING==#control.shiftDtlUdf1#'
See "DBLookups" in the Infor Workforce Management Time and Attendance Implementation and Administration Guide for more details.