Hi AV, The idea is that Application-Delete-Entry is used with an escalation that runs on daily basis. Unless you have to delete let say 1000 recs it makes no sense to use SQL. DC
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of remedy arlist Sent: Wednesday, August 22, 2007 3:51 PM To: [email protected] Subject: Re: Deletion of Cases ** 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: [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___ __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"
