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"