Operation Details
Description: Returns the identifiers of the tasks assigned to the specified organization object with a null priority and which have been assigned to that object for longest period of time.
Sterotype: nsmulti
SQL
SELECT
  t.taskID,
  t.versionNo
INTO
  :taskID,
  :versionNo
FROM
  TaskAssignment ta,
  Task t
WHERE
        ta.relatedID = :relatedID
AND ta.assigneeType = :assigneeType
AND ta.taskID = t.taskID
AND t.reservedBy IS NULL
AND t.priority IS NULL
ORDER BY 
  t.assignedDateTime ASC