Database SQL Operation: TaskUserAssignment.countOpenTaskAssignByUser
Description: | Counts the number of open tasks assign to the specified user.
@deprecated Since Curam 6.0. The TaskUserAssignment entity has been deleted. This method has been replaced by {@link curam.core.sl.entity.intf.TaskAssignment#countOpenTaskAssignByUser(TaskUserNameStatusAndRestartDateTimeKey)}. See release note CR00223130. |
Sterotype: | ns |
SELECT
COUNT (*)
INTO
:numberOfRecords
FROM
TaskUserAssignment,
Task
WHERE TaskUserAssignment.userName = :reservedBy
AND Task.taskID = TaskUserAssignment.taskID
AND Task.status = :status
|