Operation Details
Description: Returns the unreserved task identifier based on user name and nearest assigned date. There may be more than one record matching the search criteria as system generated tasks could have the same assigned date time. @deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment# searchTasksAssignedToOrgObjectNearestToDate(TaskIDRelatedIDAndTypeKey)}. See release note CR00223130.
Sterotype: nsmulti
SQL 
SELECT
  Task.taskID
INTO
  :taskID 
FROM
  TaskUserAssignment,
  Task 
WHERE TaskUserAssignment.userName = :userName 
  AND TaskUserAssignment.taskID = Task.taskID 
  AND Task.reservedBy IS NULL 
  AND Task.assignedDateTime = 
  ( 
  SELECT
    MAX(assignedDateTime) 
  FROM
    TaskUserAssignment,
    Task 
  WHERE TaskUserAssignment.userName = :userName 
    AND TaskUserAssignment.taskID = Task.taskID 
    AND Task.assignedDateTime <= :assignedDateTime 
    AND Task.reservedBy IS NULL 
  )