Task Productivity Report View

Table 34-25 describes the WFPRODUCTIVITY_VIEW report view.

Table 34-25 Task Productivity Report View

^Footnote 1

For completed tasks, the state is null. Use decode(outcome, '', 'COMPLETED', outcome) in queries.

For example:

Count the number of unique tasks that the user has updated in the last 30 days, as shown below:

SELECT username, count(distinct(taskid))  FROM WFPRODUCTIVITY_VIEW WHERE
 lastupdateddate > (current_date -30) GROUP BY username;

Count the number of tasks that the user has updated (one task may have been updated multiple times) in the last seven days, as shown below:
```
SELECT username, count(taskid)  FROM WFPRODUCTIVITY_VIEW  WHERE
 lastupdateddate > (current_date -7) GROUP BY username;
```

Count the number of tasks of each task type on which the user has worked, as shown below:

SELECT username, taskname, count(taskid) FROM WFPRODUCTIVITY_VIEW GROUP
 BY username, taskname;

Count the number of tasks of each task type that the user has worked on in the last 100 days, as shown below:

SELECT username, taskname, count(taskid) FROM WFPRODUCTIVITY_VIEW WHERE
 lastupdateddate > (current_date -100) GROUP BY username, taskname;