Re: Reg: Deletion of Cases
You did not specify which platform you use but if you're on 6.3 or greater I would look into the Archiving feature. You can use this to archive records to NULL, i.e. delete them from your form based on a search. The benefit of this approach is that it does not clutter the Escalation thread; it uses the dedicated Archiving thread. -- Met vriendelijke groet / Kind regards Michiel Beijen __ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl 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 = 'CASE1234' Please help me achieve the same. Regards, AV __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
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 = 'CASE1234' Please help me achieve the same. Regards, AV ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Reg: Deletion of Cases
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 = 'CASE1234' 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! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
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 = 'CASE1234' 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Reg: Deletion of Cases
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: 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 = 'CASE1234' 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
Re: Reg: Deletion of Cases
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 = 'CASE1234' 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