Operation Details
Description: Reads the latest record with the given related identifier and of the given type.
Sterotype: ns
SQL 
SELECT 
  CONTENTMANAGEMENTSYSTEMLINK.LINKID,
  CONTENTMANAGEMENTSYSTEMLINK.CMSOBJECTID,
  CONTENTMANAGEMENTSYSTEMLINK.VERSIONNO
INTO
  :linkID,
  :cmsObjectID,
  :versionNo
FROM 
  CONTENTMANAGEMENTSYSTEMLINK
WHERE
  CONTENTMANAGEMENTSYSTEMLINK.relatedID = :relatedID AND
  CONTENTMANAGEMENTSYSTEMLINK.relatedType = :relatedType AND
  CONTENTMANAGEMENTSYSTEMLINK.lastModified =
(SELECT 
MAX(CONTENTMANAGEMENTSYSTEMLINK.lastModified) 
FROM CONTENTMANAGEMENTSYSTEMLINK
WHERE
CONTENTMANAGEMENTSYSTEMLINK.relatedID = :relatedID AND
CONTENTMANAGEMENTSYSTEMLINK.relatedType = :relatedType)