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: [email protected] 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: [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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
