Clarity

We may see issues with resource who don't receive email notifications. Following tip will show how to query DB and find out what notifications have been disabled:

SELECT USER_ID, NOTIFICATION_TYPE, METHOD
FROM CLB_NOTIFICATION_PREFS
 

CLB_NOTIFICATION_PREFS is the table JUST for disabled notifications. Check with user to enable his/her notifications via Clarity UI (Account settings -> notifications)

Note: List of all types of notifications:

NOTIFICATION_TO_DO_TYPE
NOTIFICATION_CHANGES
NOTIFICATION_DISCUSSION_TYPE
NOTIFICATION_DOCUMENT_TYPE
NOTIFICATION_ESCALATION
NOTIFICATION_EVENT_TYPE
NOTIFICATION_FIN_MANAGEMENT
NOTIFICATION_INCIDENTS
NOTIFICATION_ISSUES
NOTIFICATION_WORKFLOW
NOTIFICATION_PROJ_PARTICIPANTS
SCHEDULER_TYPE
NOTIFICATION_REQUISITIONS
NOTIFICATION_RISKS
NOTIFICATION_TIMESHEETS_TYPE

Aurora_Gaimon:

We may see issues with resource who don't receive email notifications. Following tip will show how to query DB and find out what notifications have been disabled:

SELECT USER_ID, NOTIFICATION_TYPE, METHOD
FROM CLB_NOTIFICATION_PREFS
 

CLB_NOTIFICATION_PREFS is the table JUST for disabled notifications. Check with user to enable his/her notifications via Clarity UI (Account settings -> notifications)

 

 

Note: List of all types of notifications:

NOTIFICATION_TO_DO_TYPE
NOTIFICATION_CHANGES
NOTIFICATION_DISCUSSION_TYPE
NOTIFICATION_DOCUMENT_TYPE
NOTIFICATION_ESCALATION
NOTIFICATION_EVENT_TYPE
NOTIFICATION_FIN_MANAGEMENT
NOTIFICATION_INCIDENTS
NOTIFICATION_ISSUES
NOTIFICATION_WORKFLOW
NOTIFICATION_PROJ_PARTICIPANTS
SCHEDULER_TYPE
NOTIFICATION_REQUISITIONS
NOTIFICATION_RISKS
NOTIFICATION_TIMESHEETS_TYPE

 

 

Thanks for the tip Aurora! Have a great week!

Thanks Aurora, great tip and great clarification "CLB_NOTIFICATION_PREFS is the table JUST for disabled notifications"

Martti K.

Thanks a lot for the tip Aurora...

We will need to update this post to reflect pre and post 14.3 behaviours.

Reference: Re: Notifications in Clarity 14.3