Скачать или смотреть Notification Menu in Navigation Bar | Oracle APEX 20.1

What you will learn in this video:
1. How to Import Plug-ins your Application
2. How to Use Plug-ins from Shared Components
3. How to Create Dynamic Action

What you will do:
1. Download the Plug-In
2. Import the Plug-In in apps Shared Components
3. Create a Dynamic Action in Global Page
Name : Notification
True Action : Select the Plug-Ins
SQL Source : Customize as you wish
--=== SourceCode ====
-- Create a Table and Insert Message
CREATE TABLE mgmsg(
xmsgid number NOT NULL,
xsubject varchar2(100) ,
xmsg varchar2(1000) ,
xcatmsg varchar2(100) ,
xto varchar2(500) ,
icon_img varchar2(100)
)

--SQL Source code of Dynamic Action
SELECT /* sets the icon of the list item (fa-exclamation-triangle) */
nvl(icon_img,'fa-exclamation-triangle') AS NOTE_ICON,
/* sets the color of the list icon */
'rgb(192,0,15)' AS NOTE_ICON_COLOR,
/* sets the title of the list item (html possible) */
xsubject AS NOTE_HEADER,
/* sets the text of the list item (html possible */
--'My first Notification ' AS NOTE_TEXT,
XMSG AS NOTE_TEXT,
/* set the link when click on list item */
'javascript:alert("Click on Notification Entry");void(0);' AS NOTE_LINK,
/* sets the color of the left box shadow */
'rgb(192,0,15)' AS NOTE_COLOR,
/* Link or js that is executed when press accept link (if left or null not accept is shown */
'javascript:alert("Accepted");void(0);' AS NOTE_ACCEPT,
/* Link or js that is executed when press decline link (if left or null not decline is shown */
'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
FROM
MGMSG

For More Videos,
Please Subscribe our Channel:
https://bit.ly/35mJxNL

Facebook:
Page : https://bit.ly/35p45oV
Group :https://bit.ly/3db9xOE

Download Notification Plugin:
https://bit.ly/2T8uiTF

Our Published Video Link :
How to add Image Slider :    • How to add Image Slider in Oracle Apex 20.1  
Navigation Menu Search :    • Oracle APEX Navigation Menu Search  
Custom and Dynamic Navigation Menu :    • Oracle APEX Custom and Dynamic Navigation ...  
Customize Login Page Logo & Background :    • Customize Login Page | Logo and Background...  
Dynamically Change Login Page Background Image:    • Customize Login Page | Logo and Background...  
Oracle Apex 20.1 New Features :    • Oracle Apex 20.1 New Features | Part-1  

#OracleApex #OracleApexTutorials #pkzaman