Database SQL Operation: TaskWorkQueueAssignment.searchWorkQueueTasksDueInTheNextTimePeriod
Description: | Searches for tasks that are due for a specified work queue within the supplied date range, and returns a count of such tasks grouped by date due.
@deprecated Since Curam 6.0. The TaskUserAssignment entity has been
deleted. This method has been replaced by
{@link curam.core.sl.entity.intf.TaskAssignment#
searchTasksDueInTheNextTimePeriod(TasksByDueDateKey)}. See release note
CR00223130. |
Sterotype: | nsmulti |
SELECT
w.deadlineTime,
t.reservedBy
INTO
:deadlineDateTime,
:reservedBy
FROM
Task t
LEFT OUTER JOIN
WorkflowDeadline w
ON (t.taskID = w.taskID)
WHERE w.deadlineTime >= :fromDeadlineDateTime
AND w.deadlineTime < :toDeadlineDateTime
AND
(
t.taskID IN
(
SELECT
taskID
FROM
TaskWorkQueueAssignment wq
WHERE wq.workQueueID = :workQueueID
)
)
ORDER BY w.deadlineTime
|