GET_TASK_HISTORY Function

Caution:

This API is deprecated and will be removed in a future release.

Use APEX_HUMAN_TASK instead.

This function gets the approval log for a task.

This function only returns data in the context of a valid Oracle APEX session. It returns no data in SQL Workshop.

Syntax

APEX_APPROVAL.GET_TASK_HISTORY (
    p_task_id        IN NUMBER,
    p_include_all    IN VARCHAR2 DEFAULT 'N' )
RETURN apex_t_approval_log_table pipelined;

Parameters

Parameter	Description
p_task_id	The task ID.
p_include_all	If set to Y, the history of all tasks linked to the task with the given task ID is shown. Since Oracle APEX release 22.2, this includes prior Tasks that have been expired.

Returns

A table of approval log entries (type apex_t_approval_log_table) containing the following columns:

• display_msg varchar2(4000)

• event_creator varchar2(255)

• event_creator_lower varchar2(255)

• event_timestamp timestamp with time zone

• event_type varchar2(255)

• event_type_code varchar2(32)

• new_actual_owner varchar2(255)

• new_actual_owner_lower varchar2(255)

• new_priority number

• new_priority_level varchar2(255)

• new_state varchar2(255)

• new_state_code varchar2(32)

• old_actual_owner varchar2(255)

• old_actual_owner_lower varchar2(255)

• old_priority number

• old_priority_level varchar2(255)

• old_state varchar2(255)

• old_state_code varchar2(32)

• outcome varchar2(255)

• outcome_code varchar2(32)

Example

select *  from table ( apex_approval.get_task_history ( p_task_id => 1234,
                                                 p_include_all => 'Y' ) )