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: [email protected]
Subject: Re: Deletion of Cases
Date: Wed, 22 Aug 2007 13:50:44 +0100
**
--- [EMAIL PROTECTED] wrote:
From: remedy arlist <[EMAIL PROTECTED]>
To: [email protected]
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:[email protected] ] On Behalf Of remedy arlist
Sent: Wednesday, August 22, 2007 11:37 AM
To: [email protected]
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___
