Task Priority Report View
Table 34-26 describes the WFTASKPRIORITY_VIEW report view.
Table 34-26 Task Priority Report View
| Name | Type |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Footnote 1
NOT NULL column
For example:
-
Query the number of tasks updated by each user in each task priority, as shown below:
SELECT updatedby, priority, count(taskid) FROM WFTASKPRIORITY_VIEW GROUP BY updatedby, priority;
-
Query task-to-outcome distribution, as shown below:
SELECT taskname, decode(outcome, '', 'COMPLETED', outcome), count (taskid) FROM WFTASKPRIORITY_VIEW GROUP BY taskname, outcome;
-
Query the number of tasks updated by the given user in each priority, as shown below:
SELECT priority, count(taskid) FROM WFTASKPRIORITY_VIEW WHERE updatedby='jstein' GROUP BY priority;