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"
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 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
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 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
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: Deletion of Cases
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 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 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 = 'CASE1234' 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"
Re: Deletion of Cases
** You could use the process: Application-Query-Delete-Entry 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.ORGSubject: Re: Deletion of CasesDate: 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 arlistSent: Wednesday, August 22, 2007 11:37 AMTo: 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 = 'CASE1234' 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___
Re: Deletion of Cases
Hi AV, The idea is that Application-Delete-Entry is used with an escalation that runs on daily basis. Unless you have to delete let say 1000 recs it makes no sense to use SQL. DC From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of remedy arlist Sent: Wednesday, August 22, 2007 3:51 PM To: arslist@ARSLIST.ORG 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: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 = 'CASE1234' 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"
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: Deletion of Cases
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: arslist@ARSLIST.ORG 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: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 = 'CASE1234' 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"
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:* 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 = 'CASE1234' > > 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Deletion of Cases
I believe proper formatting of the run-if you stated below would be to put the calculations with the $TIMESTAMP$ keyword rather than the field so you do not have to re-perform the calculation on each row in the table. I'm not quite sure why remedy performs the calculation agains the field. Below would be the calculation re-written: 'Create Date' <= ($TIMESTAMP$ - (((30 * 24) * 100) * 60)) Personally, I would have written it: 'Create Date' <= ($TIMESTAMP$ - (((60 * 60) * 24) * 50)) Both are fifty days, the second is just more apparent. I'm not sure why remedy is making their date calculation so confusing. I had to pull out a calculator to found out how many days that was, where with mine you can easily see it is fifty days. RemedyArslist, you would want that to be the qualfiation, and look into doing a Run Process action of: Application-Delete-Entry "$SCHEMA$" $Request ID$; I think that Daniel pointed out a good idea of using the already existing CleanupAlertEvents escalation (just make sure to change the run-if to do the data calculation against $TIMESTAMP$ instead of the 'Create Date' field). It is attached to the Alert Events form in Remedy. 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 CONDREA, Daniel Sent: Wednesday, August 22, 2007 3:51 AM To: arslist@ARSLIST.ORG Subject: Re: Deletion of Cases ** 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: 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 = 'CASE1234' 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Deletion of Cases
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: 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 = '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"