Configuring the job filter for templates to check for job effective dates

  1. Navigate to Scheduling > Multi-view Scheduler > Advanced Schedule View.
  2. Click the Turn ON config mode icon. This is the asterisk (*) on the top menu bar.
  3. Click the plus sign (+) to create an ad-hoc shift.
  4. Click the orange diamond icon next to the SCHED_TMPL_JOB field.
  5. Update the SQL statement in Field Parameters. Where it shows ~FILTER_JOBS_DATE_EFFECTIVE==false, change "false" to "true." 
    sourceDisplayFields=JOB_LOC_NAME 
sourceType=REGISTERED source=SEC_JOB_LOOKUP 
sourceParams='FILTER_JOBS_BY_TEAM==true~|~FILTER_JOBS_DATE_EFFECTIVE==true~
|~jobTeam==#InputField.jobTeam#~|~jobStartDate==#inputField.jobStartDate#' 
labelFieldStatus=edit title=LOOKUP_JOB' sourceKeyField=JOB_ID
  6. Click Save.