Database SQL Operation: TaskAssignment.searchUnreservedByRelatedIDNullPriorityLongestAssignedDateTime
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 |
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
|