From the Admin account side - I see some records under Notifications.
Examples
If a resource is added to Project/Task - he receives email.
Some custom process will triggers emails to users on Timesheet failures
A user is usually assigned to Action items, to complete them
So are the above examples will be seen under this Notifications section?
I tried to join the Table but not able to get below view in terms of Query - Please correct it.
/* Half completed Query */
SELECT
notif.*
FROM clb_notifications notif
JOIN clb_notification_prefs pref ON pref.user_id = notif.receiver_id
WHERE pref.notification_type='NOTIFICATION_CHANGES'
and notif.event_type='NOTIFICATION_RISKS'