How to add Notification menu Navigation bar in oracle apex | Oracle apex...

In this video we learn how to dynamic or user define add notification menu plugin on navigation bar in oracle apex.

Plugins link:

https://apex.world/ords/f?p=100:710:2...

Quick SQL script
=================
notifications
id num /pk
notify_type vc 200
notify_sms vc 200
icons vc 100

PL/SQL Code

Icons
================
fa-alert
fa-bell-o
fa-warning

SQL Source code of Dynamic Action

==================

SELECT /* sets the icon of the list item (fa-exclamation-triangle) */

nvl(icons,'fa-exclamation-triangle') AS NOTE_ICON,

'rgb(192,0,15)' AS NOTE_ICON_COLOR,

/* sets the color of the list icon */

/* sets the text of the list item (html possible */

/* sets the title of the list item (html possible) */
notify_type AS NOTE_HEADER,

/* set the link when click on list item */

--'My first Notification ' AS NOTE_TEXT,
notify_sms AS NOTE_TEXT,

'rgb(192,0,15)' AS NOTE_COLOR,

'javascript:alert("Click on Notification Entry");void(0);' AS NOTE_LINK,
/* sets the color of the left box shadow */

'javascript:alert("Accepted");void(0);' AS NOTE_ACCEPT,

/* Link or js that is executed when press accept link (if left or null not accept is shown */
/* Link or js that is executed when press decline link (if left or null not decline is shown */

FROM

'javascript:alert("Declined");void(0);' AS NOTE_DECLINE,
/* When enable Browser Notifications in ConfigJSON then you can select which notifications should not be fire browser not. */
0 AS NO_BROWSER_NOTIFICATION

notifications