Clarity

In Clarity 14.3 there is a new option to define general system notifications, I'm trying to understand how this works in relation to previous versions

I've seen a behavior change in the table CLB_NOTIFICATION_PREFS:

- multiple records per user/notification type/method, and

- 2 new fields 'Principal_type' and 'Status'

Does anyone know where are the system default notifications stored ? , these are not saved in CLB_NOTIFICATION_PREFS

Hi Juan,

This is a new feature in Clarity that allows you to globally set the email preferences for all users at the same time, by making your selections and choosing the Publish button.

Prior to 14.3, you could only change these settings user by user via the UI by logging in as that user and making changes on the Account Settings page.

The results of changes to this page are sotred in the CLB_NOTIFICATION_PREFS table.  Only one row per notification type is stored in this table.  However, it changes all this setting for all users.  Users can still go in and make their own changes after that if they do not want the settings that were pushed to everyone.

I hope this helps.

Sincerely yours,

Jeanne Gaskill

Senior Support Engineer

CA PPM (aka Clarity)

PRINCIPAL_TYPE = 'SAVE'

These are the values stored as the system default notifications.  When you make a change to the defaults in the Administration tool, these entries will be updated.  Unless a USER has overridden this value with their own setting, any changes made here that you save will be inherited by users immediately.  The USER_ID listed against this entry indicates the user that clicked Save in the admin tool.

PRINCIPAL_TYPE = 'USER'

These are the values a user has set for themselves on their own Account Settings.  These values are removed when the user selects 'Restore Defaults'.  Only the values/entries you have made changes to will be stored.  These values take precedence over 'SAVE' level items, so the values a user has will be a combination of SAVE items they haven't changed, plus any USER items that they have set specifically.

Edit: At this 'USER' level, status = 0 is an unchecked notification, status = 1 is a checked notification.

PRINCIPAL_TYPE = 'PUBLISH'

When the publish button is clicked:

1. 'SAVE' settings are replicated as 'PUBLISH' settings.

2. All 'USER' settings are deleted.

The USER_ID listed against this entry indicates the user that clicked Publish in the admin tool.

I hope that helps clear up your question and also any other differences in behaviour you've observed.

Thank you Nick, this helps a lot.

Another question, do you know where are the system default settings stored ? is this stored in the DB or it is stored as a java blob ?

It should be in the DB, in the same table, where the principal_type column value = 'SAVE'.  They represent the system defaults shown in the screenshot.