25.1.9.1.6.3 Including Extra Columns in Task List

Expose additional GET_TASKS columns so the task list can show more task details.

In a new Unified Task List page, the Content Row region's SELECT list includes only some of available task information columns the GET_TASKS function returns. To see all of the available columns, change the query to use * for the column list as shown below:

select *
  from table ( apex_human_task.get_tasks (
                   p_context            => 'MY_TASKS',
                   p_show_expired_tasks => :P33_SHOW_EXPIRED,
                   p_application_id     => :APP_ID
                   ) )

This causes Page Designer to show all available column names under the region's Columns heading in the Rendering tab. The following table highlights a few important GET_TASKS result columns.

Table 25-2 Important GET_TASKS Result Columns

Column	Description
TASK_ID	Unique ID of this task instance
SUBJECT	Subject of this task instance
STATE_CODE	Current state of this task instance (e.g. INFO_REQUESTED)
STATE	Current state of this task instance (e.g. Information Requested)
INITIATOR	Username who created the task instance
ACTUAL_OWNER	Username of assigned potential owner
DETAIL_PK	Details Primary Key for this instance's related business entity row
TASK_DEF_STATIC_ID	Unique task definition identifier for this task instance
DETAILS_LINK_TARGET	URL of the task details page for this instance