Operation Details
Description: Reads the record depending on category,type and Issuer, which can either be the agency, organization unit or external issuer.
Sterotype: nsmulti
SQL 
SELECT
  Certification.certificationID,
  Certification.category,
  Certification.certificationType,
  Certification.issuedByAgencyInd,
  Certification.externalIssuer,
  Certification.creditsRequired,
  Certification.creditType,
  Certification.validityPeriod,
  Certification.validityPeriodUnit,
  Certification.recordStatus,
  Organisation.name,
  OrganisationUnit.name
INTO
  :certificationId,
  :category,
  :certificationType,
  :issuedByAgencyInd,
  :externalIssuer,
  :creditsRequired,
  :creditType,
  :validityPeriod,
  :validityPeriodUnit,
  :recordStatus,
  :organisationname,
  :organisationunitname 
FROM
  Certification,
  Organisation,
  OrganisationUnit 
WHERE 
  (
    :issuedByAgencyInd ='0' 
    OR Certification.issuedByAgencyInd = :issuedByAgencyInd 
  ) 
  AND 
  (
    :searchByexternalIssuer ='0' 
    OR Certification.externalIssuer = :externalIssuer 
  ) 
  AND 
  (
    :searchByorganisationUnitID ='0' 
    OR Certification.organisationUnitID = :organisationUnitID 
  ) 
  AND 
  (
    Certification.organisationUnitID =OrganisationUnit.organisationUnitID 
  )