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.

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

ABOUT THE AUTHOR

Ryan Farley

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix since 2001 and believes in sharing with the community. He loves C#, Javascript, Python, 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) news and product updates!

You have Successfully Subscribed!