Operation Details
Description: This method returns all EvidenceBrokerConfig records for a given shared type, evidence type, source and target details and recordStatus.
Sterotype: nsmulti
SQL 
SELECT
  evidenceBrokerConfigID,
  sourceType,
  sourceID,
  targetType,
  targetID,
  sourceEvidenceType,
  targetEvidenceType,
  autoAcceptInd,
  webServicesInd,
  sharedType,
  shareVerificationsOption,
  externalSystem,
  recordStatus,
  readOnlyInd,
  logicESharingRules,
  logicESharingRulesFileName,
  trustedSource,
  versionNo
INTO
  :evidenceBrokerConfigID,
  :sourceType,
  :sourceID,
  :targetType,
  :targetID,
  :sourceEvidenceType,
  :targetEvidenceType,
  :autoAcceptInd,
  :webServicesInd,
  :sharedType,
  :shareVerificationsOption,
  :externalSystem,
  :recordStatus,
  :readOnlyInd,
  :logicESharingRules,
  :logicESharingRulesFileName,
  :trustedSource,
  :versionNo 
FROM
  EvidenceBrokerConfig 
WHERE 
  (
    
    (
      sourceID = :sourceID 
      AND sourceType = :sourceType 
    ) 
    OR :sourceType IS NULL 
  ) 
  AND 
  (
    
    (
      targetID = :targetID 
      AND targetType = :targetType 
    ) 
    OR :targetType IS NULL 
  ) 
  AND 
  (
    sourceEvidenceType = :sourceEvidenceType 
    OR :sourceEvidenceType IS NULL 
  ) 
  AND 
  (
    targetEvidenceType = :targetEvidenceType 
    OR :targetEvidenceType IS NULL 
  ) 
  AND 
  (
    sharedType = :sharedType 
    OR :sharedType IS NULL 
  ) 
  AND recordStatus = :recordStatus 
ORDER BY sourceType,
  targetType,
  sourceEvidenceType,
  sharedType