GET_TASK_HISTORY Function

31.16 GET_TASK_HISTORY Function

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_HUMAN_TASK.GET_TASK_HISTORY (
    p_task_id        IN NUMBER,
    p_include_all    IN VARCHAR2 DEFAULT 'N' )
RETURN wwv_flow_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. In 22.2, this includes prior Tasks that have been expired.

Returns

A table of approval log entries (type apex_t_approval_log).

Example

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

Parent topic: APEX_HUMAN_TASK