Operation Details
Description: @deprecated by searchActiveByLinkIDLinkType1. @deprecated-since V6.0. Method to list active Contact Log details for specified Link id and Link Type. New method returns additional end date time field.
Sterotype: nsmulti
SQL
SELECT
  ContactLog.contactLogID,
  ContactLog.contactLogType,
  ContactLog.startDateTime,
  ContactLog.purpose,
  ContactLog.location,
  ContactLog.method,
  ContactLog.addendumInd
INTO
  :contactLogID,
  :contactLogType,
  :startDateTime,
  :purpose,
  :location,
  :method,
  :addendumInd 
FROM
  ContactLog,
  ContactLogLink 
WHERE ContactLogLink.linkID = :linkID 
  AND ContactLogLink.linkType = :linkType 
  AND ContactLogLink.recordStatus = :recordStatus 
  AND ContactLog.contactLogID = ContactLogLink.contactLogID 
  AND ContactLog.recordStatus = :recordStatus 
ORDER BY startDateTime DESC