You are correct, that statement only deletes one entry at a time. However, whenever you use it in an escalation, it will delete all entries that meet the Run-If qualification.
For instance, if you use the Run-If of 'Create Date' <= ($TIMESTAMP$ - (((60 * 60) * 24) * 50)) and there were 1,000 tickets that met it, then your escalation would delete all 1,000 of those tickets. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of remedy arlist Sent: Wednesday, August 22, 2007 7:51 AM 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"
