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?

Keep in mind that they are not truly Orphaned.

Whenever an Activity is completed, the History record created does Store the ACTIVITYID, so you could always link it back.

That said, I do agree that these records lose any value once the Activity is complete, and probably should be removed from the System.

Raul,

Yes, I am aware of that.  My question basically is, what is the point of the USERNOTIFICATION records and USER_ACTIVITY records after the Activty becomes History?  Are they needed for anything?  Calendar?  Reminders for Activities that don't exist?  If there is no point in having these records at this point, why are they not deleted programatically?

some systems use the USER_ACTIVITY records to record the Attendance of a User at an Activity.....used for BILLING. The History Detail view can show a popup list of all USER_ACTIVITY records for that activity.....you just have to change the property of the control to visible......and add back in the USER_ACTIVITY records after they are deleted when the Activity is closed up...... (and now we can get into discussions about SQL Triggers for capturing On Delete events and how changing a Meeting Leader during completion of an activity does NOT create a USER_ACTIVITY record (it's going to be deleted in a few seconds anyway?!!!!)..so the most important attendee at a meeting may not have 'attended' based on the USER_ACTIVITY records....

I also thought that calendaring used the USER_ACTIVITY record to show the 'lined through' completed activities.....but this may have been versionS ago....

USERNOTIFICATIONS does affect who ultimately appears as an Attendee at an Activity.....