Clearing all Activity Notifications in Infor CRM with a SQL Statement

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.

	user_activity.alarm = 'F' 

	inner join sysdba.activity 
	on user_activity.activityid = activity.activityid 
	activity.startdate < cast('2016-12-31 00:00:00.000' as datetime) 
	user_activity.alarm = 'T' 

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


Ryan Farley

Ryan Farley is the Director of Development for Customer FX and creator of He's been blogging regularly about SalesLogix, now Infor CRM, since 2001 and believes in sharing with the community. His new passion for CRM is Creatio, formerly bpm'online. He loves C#, Javascript, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!