Hi all,
May be someone can come up with an easy way of doing this. We are running Oracle 9i, ARS 6.0, and Helpdesk 5.0. I have to delete records that are closed for more than 3 years. There are two areas of concern: Some of these records have related items. Although the (parent) ticket may have been closed for more than 3 years, if it has a related ticket that is still open, we do not want to close the (parent) ticket. The same is with Task. If a Change Request has several Tasks, and some of the Task have been closed; we don't want to delete those Tasks if the Change Request is still open. Has anyone done these before? Bola Oyefeso _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<image001.gif>>
