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!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Completed activities creating history, but not deleteing from activity table

Steve Knowles
Posts: 657

Completed activities creating history, but not deleteing from activity table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 14 Nov 07 10:27 AM

I have 470 records returned from this query:
select * from history h, activity a where h.activityID=a.activityID

Which indicates to me that some activity records are not getting deleted when moved to history. Am I on track here? Is it ok to delete the activity record if it also exists in the History table? The activity records in question don't show up on the front end either.. Thanks

[Reply][Quote]

Jeff Weight
Posts: 219

Re: Completed activities creating history, but not deleteing from activity table Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 15 Nov 07 10:13 AM

Could it be the activities are recurring activities? Seems strange that they wouldn't be deleted. You might want to run the profiler and complete a few activities to see what it is doing and maybe what it is looking for before deciding to delete an activity.

Either way, to answer your question, it's always OK to delete an activity record

I believe activities records sometimes have sister records in other tables, like the User_Activity table, or the UserNotification table - I'm not sure - so you'll want to delete those as well.

[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): 7/9/2025 6:42:03 PM