RonnyWeiss
Update table when accept/decline a notification
Hello, I am using notification plugin menu to display notifications from a table and it is perfectly shows the data. I have a table column named: NOTIF_READ (1-Read,0-Unread), and my notification count displays unread notifications. What I want do is when I click accept/decline link, I want to update this column in the database, so that it renders the correct notification/notification count on refresh. This is my source sql as mentioned below. Is there a way with which we can run Pl/SQL code or something else on clicking accept/decline link ? At the moment it is running JS code only.
SELECT anc.NOTIF_ICON AS NOTE_ICON, anc.NOTIF_ICON_COLOR AS NOTE_ICON_COLOR, anc.NOTIF_HEADER AS NOTE_HEADER, replace(anc.NOTIF_TEXT, '#PID#', an.PID) AS NOTE_TEXT, anc.NOTIF_LINK AS NOTE_LINK, anc.NOTIF_COLOR AS NOTE_COLOR, 'javascript:alert("Accepted");void(0);' AS NOTE_ACCEPT, 'javascript:alert("Declined");void(0);' AS NOTE_DECLINE, anc.NOTIF_BROWSER_NOTIF AS NO_BROWSER_NOTIFICATION FROM MANN_APEX_NOTIFICATIONS an, MANN_APEX_NOTIFICATIONS_CONFIG anc WHERE an.NOTIFCNF_ID = anc.NOTIFCNF_ID and an.NOTIF_RECEIVER = :APP_USER and anc.notifcnf_name='S2P_TASK_REASSIGNMENT' and an.NOTIF_READ = 0 order by an.created_date desc
