Deletion of non-reference entry mechanism
Hi all, I need your attention on this one. I am becoming creative and I wonder if I should. I am trying to figure how to automaticly delete the entries which have no more reference to their parent. Let me explain the situation first. I have one form called Parent and a second one called Child(Parent and child relation). First, once a user opens a new Parent form I generate a GUID. I am using the GUID because the user might create a child relation before they save the form(In that specific case I could not transfer the RequestID). That way, I can transfer it(GUID) to my child form in order to keep my reference. However, if my users dont save their parent form and just cancel it I would like to delete all the child entries which are now useless. Now that everyone understand the situation what is the best approach taking in consideration that I have multiple application and multiple parent and child relation. I would like to avoid the redundancy in the way I develop this to come up with a generic mechanism. Here is what I did so far: 1- Form Name = AutoDeletionEntry a) Character field = EntryToDelete (Form and Entry to delete) b) Filter on sumbit run process Application-Delete-Entry $EntryToDelete$ I use the form and filter above to automaticly delete an entry from a button. From now on, all the delete entry occure from an action uses the form and filter state above. It works like a charm. I would like to use the same form and filter (if possible) to delete my orphans. In fact, I was taking about creating a escalation job to detect my orphans in order to push the values (Form name and EntryID) to my AutoDeletionEntry form but I cannot get any generic way of managing all the forms at once. Any suggestion? Mathieu Pitre IT Business Systems Analyst CSC @ PWC ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Deletion of non-reference entry mechanism
Have you considered the possibility of preventing the orphans to begin with?...If you create an AL that happens on Window Close where Operation = CREATE that does a delete query on it's child tables base on the GUID you have already generated...if you wanted to keep it dynamic...you could push the Form and GUID to another form to create a new record and then have that one do a lookup of which tables are children of the parent in question and then have a filter do the delete query action. L. J. Head Software Engineer Remedy Approved Consultant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre Sent: Friday, September 01, 2006 8:33 AM To: arslist@ARSLIST.ORG Subject: Deletion of non-reference entry mechanism Hi all, I need your attention on this one. I am becoming creative and I wonder if I should. I am trying to figure how to automaticly delete the entries which have no more reference to their parent. Let me explain the situation first. I have one form called Parent and a second one called Child(Parent and child relation). First, once a user opens a new Parent form I generate a GUID. I am using the GUID because the user might create a child relation before they save the form(In that specific case I could not transfer the RequestID). That way, I can transfer it(GUID) to my child form in order to keep my reference. However, if my users dont save their parent form and just cancel it I would like to delete all the child entries which are now useless. Now that everyone understand the situation what is the best approach taking in consideration that I have multiple application and multiple parent and child relation. I would like to avoid the redundancy in the way I develop this to come up with a generic mechanism. Here is what I did so far: 1- Form Name = AutoDeletionEntry a) Character field = EntryToDelete (Form and Entry to delete) b) Filter on sumbit run process Application-Delete-Entry $EntryToDelete$ I use the form and filter above to automaticly delete an entry from a button. From now on, all the delete entry occure from an action uses the form and filter state above. It works like a charm. I would like to use the same form and filter (if possible) to delete my orphans. In fact, I was taking about creating a escalation job to detect my orphans in order to push the values (Form name and EntryID) to my AutoDeletionEntry form but I cannot get any generic way of managing all the forms at once. Any suggestion? Mathieu Pitre IT Business Systems Analyst CSC @ PWC ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Deletion of non-reference entry mechanism
I dont see how that would work (you could push the Form and GUID to another form to create a new record and then have that one do a lookup of which tables are children of the parent in question and then have a filter do the delete query action. ) How dont see how it would work because I cannot lookup at the different forms dynamically in the same escalation. Unless I am wrong but here is what I was thinking about: Push 3 values in the OrphansToDelete form 1- The GUID 2- The parent form name 3- The child form name The problem is that I cannot use a generic way of querying on the proper form. I would need to do a SQL query but the table names vs the remedy schema are not nesserary the same. Can I get the real oracle table name from the Remedy schema name. I would then use the returned value to create an SQL query dynamically. >From there I will know if the entry is a real orphan or not. I need your help guys! Mathieu Pitre IT Business Systems Analyst Production Operation Computer Sciences Corporation Pratt Whitney Canada, Plant 1 Sametime: Mathieu Pitre office: 450-647-8008 x7030 This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. L. J. Head [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/09/2006 02:12 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Deletion of non-reference entry mechanism Have you considered the possibility of preventing the orphans to begin with?...If you create an AL that happens on Window Close where Operation = CREATE that does a delete query on it's child tables base on the GUID you have already generated...if you wanted to keep it dynamic...you could push the Form and GUID to another form to create a new record and then have that one do a lookup of which tables are children of the parent in question and then have a filter do the delete query action. L. J. Head Software Engineer Remedy Approved Consultant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre Sent: Friday, September 01, 2006 8:33 AM To: arslist@ARSLIST.ORG Subject: Deletion of non-reference entry mechanism Hi all, I need your attention on this one. I am becoming creative and I wonder if I should. I am trying to figure how to automaticly delete the entries which have no more reference to their parent. Let me explain the situation first. I have one form called Parent and a second one called Child(Parent and child relation). First, once a user opens a new Parent form I generate a GUID. I am using the GUID because the user might create a child relation before they save the form(In that specific case I could not transfer the RequestID). That way, I can transfer it(GUID) to my child form in order to keep my reference. However, if my users dont save their parent form and just cancel it I would like to delete all the child entries which are now useless. Now that everyone understand the situation what is the best approach taking in consideration that I have multiple application and multiple parent and child relation. I would like to avoid the redundancy in the way I develop this to come up with a generic mechanism. Here is what I did so far: 1- Form Name = AutoDeletionEntry a) Character field = EntryToDelete (Form and Entry to delete) b) Filter on sumbit run process Application-Delete-Entry $EntryToDelete$ I use the form and filter above to automaticly delete an entry from a button. From now on, all the delete entry occure from an action uses the form and filter state above. It works like a charm. I would like to use the same form and filter (if possible) to delete my orphans. In fact, I was taking about creating a escalation job to detect my orphans in order to push the values (Form name and EntryID) to my AutoDeletionEntry form but I cannot get any generic way of managing all the forms at once. Any suggestion? Mathieu Pitre IT Business Systems Analyst CSC @ PWC ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Deletion of non-reference entry mechanism
** My approach is a preventative measure instead of an escalation type of thing Setup: Form with fields 'Parent' and 'Child' This form keeps track of al of your parent child relationships...which forms have children forms and the sort Form with fields 'Parent GUID' and'Parent Form' This will be the temp holding place to store your 'delete these things' record You then would have an AL that fires on close of any window that is in submit mode...maybe doing some sort of flag field that fires on after submit that indicates if a submit occurred and not fire if one did. This AL could do a push to your 'delete these things' form with its GUID and $SCHEMA$. That form might have a table field that lists all of the children forms of that $SCHEMA$ value that was submitted. This filter does a loop through the table and issues a delete query to each form in the table for the GUID submitted. I have never performed this type of thing so I'm just coding off the top of my head...and it might not work quite like I'm thinking...but it should cause any submit window that is closed without a submit to cause each of its children windows to be purged of any children records that were created immediately...instead of doing it in an escalation Feel free to contact me off list if you have questions about what I'm thinking about L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu PitreSent: Friday, September 01, 2006 1:32 PMTo: arslist@ARSLIST.ORGSubject: Re: Deletion of non-reference entry mechanism I dont see how that would work (you could pushthe Form and GUID to another form to create a new record and then have thatone do a lookup of which tables are children of the parent in question andthen have a filter do the delete query action. ) How dont see how it would work because I cannot lookup at the different forms dynamically in the same escalation. Unless I am wrong but here is what I was thinking about: Push 3 values in the OrphansToDelete form 1- The GUID 2- The parent form name 3- The child form name The problem is that I cannot use a generic way of querying on the proper form. I would need to do a SQL query but the table names vs the remedy schema are not nesserary the same. Can I get the "real" oracle table name from the Remedy schema name. I would then use the returned value to create an SQL query dynamically. From there I will know if the entry is a real orphan or not. I need your help guys! Mathieu Pitre IT Business Systems AnalystProduction OperationComputer Sciences CorporationPratt Whitney Canada, Plant 1Sametime: Mathieu Pitreoffice: 450-647-8008 x7030This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. "L. J. Head" [EMAIL PROTECTED] Sent by: "Action Request System discussion list(ARSList)" arslist@ARSLIST.ORG 01/09/2006 02:12 PM Please respond toarslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Deletion of non-reference entry mechanism Have you considered the possibility of preventing the orphans to beginwith?...If you create an AL that happens on Window Close where Operation ="CREATE" that does a delete query on it's child tables base on the GUID youhave already generated...if you wanted to keep it dynamic...you could pushthe Form and GUID to another form to create a new record and then have thatone do a lookup of which tables are children of the parent in question andthen have a filter do the delete query action. L. J. HeadSoftware EngineerRemedy Approved Consultant-Original Message-From: Action Request System discussion list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of Mathieu PitreSent: Friday, September 01, 2006 8:33 AMTo: arslist@ARSLIST.ORGSubject: Deletion of non-reference entry mechanismHi all,I need your attention on this one.I am becoming creative and I wonder if I should. I am trying to figure howto a