Hi Guys,
The command Application-Delete-Entry "$SCHEMA$" $Request ID$; can be used to perform single delete only. Do anyone knows how to perform deletion for bulk of data. Using of create date less then a specific date was not a bull's eye in my case. Please advice. Regards, AV On 8/22/07, CONDREA, Daniel <[EMAIL PROTECTED]> wrote: > > ** 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:* arslist@ARSLIST.ORG > *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___ > __20060125_______________________This posting was submitted with HTML in > it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"