Operation Details
Description: Returns the identifiers of the tasks assigned to the specified organization object on the date nearest to the specified date. @deprecated Since Curam 6.0 SP2. This method has been replaced by two distinct functions that cater for tasks assigned to organization objects and those assigned to users. {@link curam.core.sl.entity.intf.TaskAssignment#searchUnreservedByRelatedIDNullPriorityLongestAssignedDateTime(TaskIDRelatedIDAndTypeKey)}. {@link curam.core.sl.entity.intf.TaskAssignment#searchUnreservedByRelatedNameNullPriorityLongestAssignedDateTime(TaskIDRelatedIDAndTypeKey)}. See release note CR00290609.
Sterotype: nsmulti
SQL 
SELECT
  t.taskID,
  t.versionNo
INTO
  :taskID,
  :versionNo
FROM
  TaskAssignment ta,
  Task t
WHERE
    (:searchByRelatedIDInd = '0' OR ta.relatedID = :relatedID)
AND (:relatedName IS NULL OR ta.relatedName = :relatedName)
AND ta.assigneeType = :assigneeType
AND ta.taskID = t.taskID
AND t.reservedBy IS NULL
AND t.priority IS NULL
ORDER BY 
  t.assignedDateTime ASC