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