GET_FEEDBACK Function

This function exports user feedback to the development environment or developer feedback to the deployment environment.

Syntax

APEX_EXPORT.GET_FEEDBACK (
    p_workspace_id      IN NUMBER,
    p_with_date         IN BOOLEAN  DEFAULT FALSE,
    p_since             IN DATE     DEFAULT NULL,
    p_deployment_system IN VARCHAR2 DEFAULT NULL )
    RETURN apex_t_export_files;

Parameters

Parameters	Description
`p_workspace_id`	The workspace id.
`p_with_date`	If `TRUE`, include export date and time in the result.
`p_since`	If set, only export feedback that has been gathered since the given date.
`p_deployment_system`	If NULL, export user feedback. If not NULL, export developer feedback for the given deployment system.

Returns

A table of apex_t_export_file.

Example 1

Export feedback to development environment.

declare
     l_file apex_t_export_files;
begin
     l_file := apex_export.get_feedback(p_workspace_id => 12345678);
end;

Example 2

Export developer feedback in workspace 12345678 since 8-MAR-2010 to deployment environment EA2.

declare
    l_file apex_t_export_files;
begin
    l_file := apex_export.get_feedback (
                  p_workspace_id => 12345678,
                  p_since => date'2010-03-08',
                  p_deployment_system => 'EA2' );
end;