Configuring labor metric change modals

For example, when a user clicks Change Project in the Clock Options modal, a separate Change Project modal is shown. By default this modal displays only the project codes, so you might want to show the descriptions as well.

To configure these modals, select Maintenance > System Administration > Maintenance Forms and edit the SS_PORTAL_CLOCK maintenance form. The labor metric modals are defined in the Form Fields grid. For example, the Change Project modal is defined by the PORTAL_CLOCK_CHANGE_PROJECT

To configure the information that is shown, edit the queries in the Field Parameters column. These examples show how to display the labor metric description in each modal.

PORTAL_CLOCK_CHANGE_DEPARTMENT (Change Department)

sourceType='SQL' source='SELECT DEPT_NAME, DEPT_LOC_NAME, DEPT_LOC_DESC
FROM VL_DEPARTMENT WHERE ? between DEPT_START_DATE and DEPT_END_DATE
ORDER BY DEPT_LOC_NAME' sourceParams='DATE==#control.workDate#'

PORTAL_CLOCK_CHANGE_DOCKET (Change Docket)

sourceType='SQL' sourceKeyField='DOCK_NAME' sourceLabelField='DOCK_LOC_NAME'
source='SELECT DOCK_NAME, DOCK_LOC_NAME, DOCK_DESC FROM VL_DOCKET
WHERE ? between DOCK_START_DATE and DOCK_END_DATE ORDER BY DOCK_LOC_NAME'
sourceParams='DATE==#control.workDate#'

PORTAL_CLOCK_CHANGE_JOB (Change Job)

sourceType='SQL' sourceKeyField='JOB_NAME' sourceLabelField='JOB_LOC_NAME'
source='SELECT JOB_NAME, JOB_LOC_NAME, JOB_DESC FROM VL_JOB
WHERE JOB_ID IN (SELECT JOB_ID FROM EMPLOYEE_JOB, EMPLOYEE, SEC_EMPLOYEE
WHERE EMPLOYEE.EMP_ID IN ? AND EMPLOYEE.EMP_ID = EMPLOYEE_JOB.EMP_ID
AND SEC_EMPLOYEE.EMP_ID = EMPLOYEE.EMP_ID AND SEC_EMPLOYEE.WBU_ID = #page.property.userId#
AND ? BETWEEN EMPJOB_START_DATE AND EMPJOB_END_DATE AND ? BETWEEN SEC_EMPLOYEE.START_DATE
AND SEC_EMPLOYEE.END_DATE) ORDER BY JOB_LOC_NAME'
sourceParams='INTLIST==#control.empIds#|DATE==#control.workDate#{~}|~DATE==#control.workDate#'

PORTAL_CLOCK_CHANGE_PROJECT (Change Project)

sourceType='SQL' sourceKeyField='PROJ_NAME' sourceLabelField='PROJ_LOC_NAME'
source='SELECT PROJ_NAME, PROJ_LOC_NAME, PROJ_DESC FROM VL_PROJECT
WHERE ? between PROJ_START_DATE and PROJ_END_DATE ORDER BY PROJ_LOC_NAME'
sourceParams='DATE==#control.workDate#' **

PORTAL_CLOCK_CHANGE_TIMECODE (Change Timecode)

sourceType='SQL' sourceKeyField='TCODE_NAME' sourceLabelField='TCODE_LOC_NAME' 
source='SELECT TCODE_NAME, TCODE_LOC_NAME, TCODE_DESC FROM VL_TIME_CODE 
ORDER BY TCODE_LOC_NAME' searchColumns='TCODE_LOC_NAME'