How to check users' custom notification settings?

Products

• Clarity PPM On Premise

Issue/Introduction

Some of our users' notification settings do not update when we update defaults and click Save. How can we see what the custom user notification preferences are? 

Environment

Release : All Supported Clarity releases

Resolution

You might want to check the table CLB_NOTIFICATION_PREFS to see if the users have custom settings if any:

select *

from CLB_NOTIFICATION_PREFS c, cmn_sec_users u

where  c.user_id = u.id and c.principal_type = 'USER'

and u.user_name ='<enter here the user name>'