Operation Details
Description: Returns a list of the task details that are reserved by the specified organization unit user and are due within the specified time period. In this instance, the task details are returned ordered by the date and time the task was reserved on, earliest first.
Sterotype: nsmulti
SQL 
SELECT
  t.taskID,
  t.priority,
  t.assignedDateTime,
  t.restartTime,
  t.wdoSnapshot,
  t.overflowInd,
  t.versionNo,
  w.deadlineTime
INTO
  :taskID,
  :priority,
  :reservedDateTime,
  :restartDateTime,
  :wdoSnapshot,
  :overflowInd,
  :versionNo,
  :deadlineDateTime 
FROM
  Task t,
  WorkflowDeadline w,
  TaskAssignment ta 
WHERE t.taskID = w.taskID 
  AND t.taskID = ta.taskID 
  AND ta.relatedName = :reservedBy 
  AND ta.assigneeType = 'RL9' 
  AND w.deadlineTime >= :fromDeadlineDateTime 
  AND w.deadlineTime < :toDeadlineDateTime 
  AND t.reservedBy = :reservedBy 
  AND t.status = :status 
ORDER BY t.assignedDateTime ASC