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

Reply via email to