Hi!
If your escalation searches for the records to delete, you should not do a
new Query.
Intead you should do the following:
Application-Delete-Entry "$SCHEMA" $1$
The FieldId of the EntryIdField is allways 1, and the above will delete
the current record.
Best Regards - Misi, RRR AB, http://www.rrr.se
> Hello Listers,
>
> I have a requirement to delete records which are 7 days old from a
> form i.e. FormA on every Saturday 9 AM.
>
> I have created an escalation in FormA with run if condition as 'Create
> Date' < ($TIMESTAMP$ - 604800) and in the if action I have created a run
> process action with the command as
>
> Application-Query-Delete-Entry "$SCHEMA$" $Create Date$ < ($TIMESTAMP$ -
> 604800)
>
> I also used the below command
>
> @: Application-Query-Delete-Entry "$SCHEMA$" $Create Date$ < ($TIMESTAMP$
> - 604800)
>
> But the above command does'nt delete the matching records from FormA.
>
> Appreciate any help ASAP.
>
> Regards,
> Ravi Kumar T
>
>
>
>
>
>
>
>
> __20060125_______________________This posting was submitted with HTML in
> it___
>
>
> DISCLAIMER:
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
> or distribution or forwarding of any or all of the contents in this
> message is STRICTLY PROHIBITED. If you are not the intended recipient,
> please contact the sender by email and delete all copies; your cooperation
> in this regard is appreciated.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
