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).
