Parameters example 3

These parameters can replace '?' in the query using 'INTLIST', as shown in Example 3:

  • request.WRKS_ID
  • request.EMP_ID

Example 3

r. sourceType=SQL sourceKeyField=JOB_NAME sourceLabelField=JOB_LOC_NAME
source='SELECT JOB_NAME, JOB_LOC_NAME, JOB_LOC_DESC FROM VL_JOB where
job_id in ( SELECT job_id from ( SELECT job_id, count(job_id) A,
numEmployees  FROM employee_job , employee , ( select count(EMP_ID)
numEmployees from employee where emp_id in (?)) qEmp WHERE
employee.emp_id in (?) and employee.emp_id = employee_job.emp_id AND
TO_DATE( cast(? as char(17)), \'yyyymmdd hh24miss\' )  >=
EMPJOB_START_DATE AND (TO_DATE( cast(? as char(17)),
\'yyyymmdd hh24miss\' ) + 6) <= EMPJOB_END_DATE group by job_id,
numEmployees) qJob where A=numEmployees ) order by job_loc_name'
sourceParams='INTLIST==#request.EMP_ID#~|~INTLIST==#request.EMP_ID#~|~
STRING==#request.START_DATE#~|~STRING==#request.START_DATE#'
width=10 labelFieldStatus=edit title='LOOKUP_JOB'