Database SQL Operation: TaskUserAssignment.searchUnreservedByUserNamePriorityAndNearestAssignedDateTime
Description: | Returns the unreserved task identifier based on user name, the priority 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#searchTasksAssignedToOrgObjectWithPriorityNearestToDate(TaskIDRelatedIDAndTypeKey)}. See release note CR00223130. |
Sterotype: | nsmulti |
SELECT
Task.taskID
INTO
:taskID
FROM
TaskUserAssignment,
Task
WHERE TaskUserAssignment.userName = :userName
AND TaskUserAssignment.taskID = Task.taskID
AND Task.priority = :priority
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.priority = :priority
AND Task.assignedDateTime <= :assignedDateTime
AND Task.reservedBy IS NULL
)
|