You are welcome... Even if for some odd process somewhere, it did try to reuse the existing record in the relationship table, I do not think it will pose a problem when it doesn't find it.. The application will check for an existing record in the association table, and not finding one, will create a new one.. And life will go on..
The most it can impact is if at some place it was using this as an audit history, but I don't think they would design it that way where a table has some information that is important and some that is not, when the status is DELETE.. That would have been a bad design.. Joe From: Antonio Maradiaga Sent: Wednesday, October 13, 2010 8:56 AM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: SHR:Association ** Thanks Joe, In my testing, found exactly what you stated: Once a relationship is removed and the status of that record is set to Delete, it is never used again...even if you re-create the same relationship (which creates a NEW relationship record). Thanks for the note and will definitely start "cleaning up" these outdate relationship records. Take care, --Antonio On Tue, Oct 12, 2010 at 3:13 PM, Joe Martin D'Souza <[email protected]> wrote: ** No harm in my opinion.. I do not think the same record is used again once set to DELETE. I would use an escalation as this would delete the record well after the transaction where the record has been set to DELETE. Joe From: Antonio Maradiaga Sent: Tuesday, October 12, 2010 9:21 AM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: SHR:Association ** ARSListers, Good morning. Had a question regarding records in the SHR:Association form (ITSM v6.3) with the STATUS value of "Delete" or the RECORD STATUS value of "Delete Pending". Once outdated relationship records tracked within this form switch to a STATUS value of "Delete", would there be any harm in removing these records via clean-up filter or escalation? Just a thought as part of some clean-up ideas to streamline the Remedy environment for a current client. Any thoughts, comments or ideas related to these outdated relationship records would be most appreicated. Thanks, --Antonio ARS v6.3 Oracle DB Unix OS ITSM v6.3 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
