Monday, 14 April 2014

How to delete error handling feedback message?

I am using a modified version of apex_error_handling_message function to log and display errors that are raised within my APEX application. Where instead of having a separate error message table error messages are logged as FEEDBACK messages using standard apex_util.submit_feedback() procedure.

On how to do this there are quite a few examples out there so I will not go into more details here.

Problem that I had and that this post is about is - OK now that application is logging all errors and they are easily visible under Team Development -> Feedback but how can I manage and monitor these from my application. 

I have found an answer goggling Oracle forums but for some reason it wasn't as easy to find on one occasion when it was pretty urgent.  So decided to post it here so that more blogs we have easier it will be to find. :)

Report query: 

SELECT feedback_number "No.",
       feedback,
       CASE
          WHEN feedback_type = 1 THEN 'General Comment'
          WHEN feedback_type = 2 THEN 'Enhancement Requested'
          WHEN feedback_type = 3 THEN 'Bug/Error'
       END
          "Type",
       CASE
          WHEN feedback_status = 0 THEN 'No Status'
          WHEN feedback_status = 1 THEN 'Acknowledged'
          WHEN feedback_status = 2 THEN 'Additional Info. Requested'
          WHEN feedback_status = 3 THEN 'Open'
          WHEN feedback_status = 4 THEN 'closed'
       END
          "Status",
       deployment_system,
       application_id,
       application_name,
       application_version,
       page_id,
       page_name,
       developer_comment,
       public_response,
       created_by,
       created_on,
       updated_by,
       updated_on
FROM   apex_team_feedback
where application_id = :APP_ID
ORDER BY updated_on DESC


 Once you get to this point it will be quite easy to create a page and write a PL/SQL that will delete any of these particular messages.

Hope it helps.

Other APEX posts on this subject:  

No comments:

Post a comment