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. Head
Software Engineer
Remedy Approved Consultant
Software Engineer
Remedy Approved Consultant
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre
Sent: Friday, September 01, 2006 1:32 PM
To: arslist@ARSLIST.ORG
Subject: 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
|
|
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 @ P&WC
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___
