Skip to Main Content
Feature Request FR-4263
Product Area Application Builder
Status CLOSED

13 Voters

Add Built-In Push Notification Logging in Oracle APEX

karepalliganesh02 Public · Feb 7 2025

Idea Summary
Add a built-in view or logging mechanism in Oracle APEX to track push notifications sent via the APEX_PUSH package. This would eliminate the need for developers to create custom tables to log notifications manually

Use Case
1. End Users can view a history of notifications they’ve received within the app, ensuring they don’t miss important updates.

2. End Users can refer back to past notifications for reference or follow-up actions.

Preferred Solution
Introduce a system view (e.g., APEX_PUSH_NOTIFICATIONS) to automatically log and display push notifications. The view should include the following columns:

NOTIFICATION_ID (unique identifier for each notification)

TITLE (title of the notification)

BODY (content/message of the notification)

USER_ID (recipient of the notification)

TARGET_PAGE_LINK (link or page to navigate when the notification is clicked)

SENT_DATE (timestamp when the notification was sent)

STATUS (e.g., READ, UNREAD)

Additionally, provide an API to update the notification status.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • sellamuthuramasamy97 OP 7 months ago

    Really nice idea. If we have this we can track all push notification logs in one place. Otherwise we need to create our custom log table and maintain it.

  • iamjsujitha OP 7 months ago

    Amazing approach.

  • thiyagu462001 OP 7 months ago

    Great idea! This will be highly beneficial for developers.

  • adamsecurer OP 7 months ago

    It will be very useful to approach notification flow effectively. Great idea @karepalliganesh02

  • vincent morneau Admin OP 7 months ago

    It was decided during the design of the push notifications feature that APEX would not keep a log of notification content for privacy purposes. You can query the web service log to get basic information about timestamps of the push notifications, or build your own wrapper to log the notifications in custom tables.