If you do this, then you need to create a control form so you can run the escalation against an individual record instead of an array of records. If you ran this escalation against your regular form, with a run-if qualification, or with it blank, then remedy would likely try to fire that Application-Query-Delete-Entry <form> <qualification_string> for each ticket there was instead of just the one time you would need to run it.
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 Greg Donalson Sent: Wednesday, August 22, 2007 8:08 AM To: arslist@ARSLIST.ORG Subject: Re: Deletion of Cases ** You could use the process: Application-Query-Delete-Entry <form> <qualification_string> For example: Application-Query-Delete-Entry "SPRT_Issue " 'Create Date' < "1/1/07" Greg --- [EMAIL PROTECTED] wrote: From: remedy arlist <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Subject: Re: Deletion of Cases Date: Wed, 22 Aug 2007 13:50:44 +0100 ** 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:arslist@ARSLIST.ORG ] 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___ __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"
