Operation Details
Description: Search for trainings which are currently offered as services for the specified training name or unit of measure.
Sterotype: nsmulti
SQL 
SELECT
  Training.trainingID,
  ServiceOffering.serviceOfferingID,
  Training.trainingName,
  Training.startDate,
  Training.endDate
INTO
  :trainingID,
  :serviceOfferingID,
  :trainingName,
  :trainingStartDate,
  :trainingEndDate 
FROM
  TrainingServiceOffering,
  ServiceOffering,
  Training 
WHERE 
  (
    :searchByTrainingName = '0' 
    OR Training.trainingNameUpper like :trainingName 
  ) 
  AND 
  (
    :searchByUnitOfMeasure = '0' 
    OR ServiceOffering.unitOfMeasure = :unitOfMeasure 
  ) 
  AND Training.trainingID = TrainingServiceOffering.trainingID 
  AND TrainingServiceOffering.serviceOfferingID = ServiceOffering.serviceOfferingID 
  AND ServiceOffering.recordStatus = :recordStatus