Clarity

  • Private Community

  • 1.  Query to Update User Notifications Values

    Posted Oct 06, 2010 08:07 PM
    Hi All,
    I am trying to set the Account Settings Notifications for all users within our test and QA systems to "unchecked". Is there a query to do this on a mass scale?

    I ran a SQL Trace, but I am not able to find the table which contains these values.

    Any help would be appreciated.

    Thanks,
    Lowell Wetzel


  • 2.  RE: Query to Update User Notifications Values
    Best Answer

    Posted Oct 07, 2010 03:45 AM
    CLB_NOTIFICATION_PREFS is the table.

    The trick is that to turn "off" a notification, you need to create a record in the table, to turn "on" the notification, you remove the record.

    This thread might give you the detail you are after;

    https://communities.ca.com/web/ca-clarity-global-user-community/message-board/-/message_boards/message/2277535