slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New Thread

View: Search:

Author

Thread: Should USERNOTIFICATION records be deleted when Activity becomes History?

Jeff Parker
Posts: 32

Should USERNOTIFICATION records be deleted when Activity becomes History? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Mar 13 10:27 AM

SLX Web Version 7.5.3.4358

I ran this query,

SELECT

* FROM USERNOTIFICATION WHERE ACTIVITYID NOT IN(SELECT ACTIVITYID FROM ACTIVITY)

and retrieved 44,000 records. Is there no mechanism to delete these records when an Activity has been completed? I suspect that these "orphaned" records are causing us problems in certain ares of SalesLogix web. These records are represented by History records with the old ActivityID but I would think there is no need for a USERNOTICICATION or a USER_ACTIVITY record at the point where an Activity record becomes History. Am I correct?

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/7/2025 7:52:07 PM