If you’ve ever imported activities into your Infor CRM (Saleslogix) database, you’ll likely hear from users that they’ve been bombarded with notifications. In some instances, you might want to clear those notifications so newly created activity notifications don’t end up getting lost in them all. Luckily, you can do that with a single SQL statement.
The following SQL statement will clear all activity notifications prior to a certain date. In this case, all notifications before December 31, 2016 will be cleared. Obviously, you could get rid of the where clause for “activity.startdate” to just clear out all notifications, regardless of date. Additionally, you could also add a clause for “activity.userid” to clear notifications for a certain user only if you’d like as well.
update user_activity set user_activity.alarm = 'F' from sysdba.user_activity inner join sysdba.activity on user_activity.activityid = activity.activityid where activity.startdate < cast('2016-12-31 00:00:00.000' as datetime) and user_activity.alarm = 'T' go
One thing to keep in mind. Activity notifications are cached, so users will need to log out and then back in again before they see the notifications disappear (a refresh isn’t enough).