8/3/2026 6:10:39 PM
|
| |
| 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!
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
Completed activities creating history, but not deleteing from activity table
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 |
|
|
|
Re: Completed activities creating history, but not deleteing from activity table
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. |
|
|
|
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!
|
|
|
|
|
|
|
|