In an escalation there is no need to use the @@: and you do not need the ; at the end ( plus you have a space after the @@ ) And if it is a Run Process action you do not need the $PROCESS$ (That is used inside a Set Fields action) The action should be: Application-Delete-Entry "SPRT:ISSUE" $Issue ID$ and I take it that Issue ID is Field ID 1 Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of remedy arlist Sent: Wednesday, August 22, 2007 8:27 AM To: arslist@ARSLIST.ORG 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"