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 = 'CASE00001234' > > 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"
