Operation Details
Description: Method returns transactionID, caseID, transactionType, transactionDateTime and userName for the given case filtered by caseID
Sterotype: nsmulti
SQL 
SELECT
  CaseTransactionLog.transactionID,
  CaseTransactionLog.caseID,
  CaseTransactionLog.transactionType,
  CaseTransactionLog.transactionDateTime,
  CaseTransactionLog.userName,
  CaseTransactionLog.relatedID,
  CaseTransactionLog.description
INTO
  :transactionID,
  :caseID,
  :transactionType,
  :transactionDateTime,
  :userName,
  :relatedID,
  :description 
FROM
  CaseTransactionLog 
WHERE CaseTransactionLog.caseID = :caseID 
ORDER BY transactionDateTime DESC