16.3 GET_FEEDBACK Function

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

Syntax

FUNCTION 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

Table 16-3 GET_FEEDBACK Function 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.

Examples

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;