Unattended Tasks Report View
Table 34-23 describes the WFUNATTENDEDTASKS_VIEW report view.
Table 34-23 Unattended Tasks Report View
| Name | Type |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Footnote 1
NOT NULL column
For example:
-
Query unattended tasks that have an expiration date of next week, as shown below:
SELECT tasknumber, taskname, assigneegroups FROM WFUNATTENDEDTASKS_VIEW WHERE expirationdate > current_date AND expirationdate < current_date + 7;
-
Query unattended tasks for
mygroup, as shown below:SELECT tasknumber, taskname, assigneegroups FROM WFUNATTENDEDTASKS_VIEW WHERE 'mygroup' IN assigneegroups;
-
Query unattended tasks created in the last 30 days, as shown below:
SELECT tasknumber, taskname, assigneegroups FROM WFUNATTENDEDTASKS_VIEW WHERE createddate > current_date -30;