Hi All,
 
Suppose that you need to trim records in a form named Form1.
 
Open Admin tool. Search for CleanupAlertEvents escalation. Save
CleanupAlertEvents escalation as CleanUpForm1. Modify CleanUpForm1 to
run on Form1.
 
The run if condition for CleanUpForm1 shoud be:
 
    ( 'Create Date' + (((30 * 24) * 100) * 60)) <= $TIMESTAMP$
 
Best regards,
Daniel

________________________________

From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of remedy arlist
Sent: Wednesday, August 22, 2007 11:37 AM
To: [email protected]
Subject: Reg: Deletion of Cases


** 
Hi List.
 
          We are using Remedy Customer Service product 6.0. I am
required to delete cases older then a specific date using a escalation.
But i am not able to get it working. The Escalation has the below
mentioned SQL statement. 
 
DELETE * from SPRT_Issue where Issue_ID = 'CASE00001234'
 
Please help me achieve the same.
 
Regards,
 
AV
__20060125_______________________This posting was submitted with HTML in
it___ 

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Reply via email to