This window aids in purging notifications and associated data from other tables.
When you enter an appropriate date in the Expiration Date Older Than column and then click the Retrieve button, rows from the Notification table that are older than or equal to this date are displayed in the lower section of the window. Clicking the folder icon () at the end of each row opens the Notification (ID) window where you can view reports and application logs. The Selected checkbox is selected by default for all retrieved rows, and all selected rows will be purged.
When you click the Purge Notifications button, a message indicates that this process purges the selected notifications and corresponding data and that, once purged, cannot be restored. If you confirm that you want to purge the selected rows, data is deleted from the following tables for that NOTIFICATION_ID:
· NOTIFICATION_DATA_ITEM
· NOTIFICATION_QUEUE
· NOTIFICATION_ATTEMPT_HIST
· NOTIFICATION_RECIPIENT (all rows that do not have any RECIPIENT_ID used in NOTIFICATION_ATTEMPT_HIST table)
· NOTIFICATION_ATTACHMENT
· ATTACHMENT (for rows deleted from NOTIFICATION_ATTACHMENT table, deletes rows in ATTACHMENT table where ATTACHMENT_ID is not used in the NOTIFICATION_ATTACHMENT table)
· NOTIFICATION
You are notified that the purge process was successfully completed or that some rows could not be deleted. Those rows that were not successfully deleted are still displayed in the window for you to take further action.