31.14 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