I think you are making this more difficult than it needs to be. Check out the escalation that remedy installs by default on the Alert Entry form.
The RUN PROCESS it shows is following: Application-Delete-Entry "$SCHEMA$" $Request ID$; You should jus tneed to use this. The action type is Run Process, so you do not need to have $PROCESS$ and since you are running it on the current server, you do not need to reference @@:. Try just putting Application-Delete-Entry "$SCHEMA$" $Request ID$; in the RUN PROCESS: field and see if it works. 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 8:26 AM To: [email protected] Subject: Re: Reg: Deletion of Cases ** I need to delete data from my UAT environment which is used by more then 40 testers. I have a data of around 12k out of which i am looking to delete 10k cases. I have created an excalation to delete only one entry (escaltion running every min) but still it doesn't work. RUN IF: 'Issue ID' = "CASE01008123" RUN PROCESS: $PROCESS$ @@ :Application-Delete-Entry "SPRT:ISSUE" $Issue ID$; The escaltion logs says: process passed. Regards, AV On 8/22/07, Marc Simmons <[EMAIL PROTECTED]> wrote: ** AV, The "Run If" qualification would find the records to delete. Then all you need is an "If" action that does a "Run Process" with the command line syntax being: Application-Delete-Entry <form_name> <entry_ID > Marc Simmons On 8/22/07, remedy arlist <[EMAIL PROTECTED] > wrote: ** 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___ -- Marc Simmons Remedy Administrator "Everyday above ground is a good day... the rest is a choice!" __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"
