14.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 wwv_flow_t_export_files;

Parameters

Table 14-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;

Parent topic: APEX_EXPORT