Operation Details
Description: Returns the deadline date time and reserved by user name of the tasks that are due for a specified user during a specified time period. The details returned include those tasks that have been directly assigned plus those tasks present on organizational object that the specified user is subscribed to.
Sterotype: nsmulti
SQL 
SELECT
  w.deadlineTime,
  t.reservedBy
INTO
  :deadlineDateTime,
  :reservedBy 
FROM
  Task t,
  WorkflowDeadline w 
WHERE t.taskID = w.taskID 
  AND w.deadlineTime >= :fromDeadlineDateTime 
  AND w.deadlineTime < :toDeadlineDateTime 
  AND t.taskID IN 
  ( 
  SELECT
    taskID 
  FROM
    TaskAssignment ta 
  WHERE 
    (
      :relatedName IS NULL 
      OR ta.relatedName = :relatedName 
    ) 
    AND 
    (
      :searchByRelatedIDInd = '0' 
      OR ta.relatedID = :relatedID 
    ) 
    AND ta.assigneeType = :assigneeType 
  ) 
ORDER BY deadlineTime