Help On Deleting Record
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
Re: Help On Deleting Record
Hi, use the archiving feature in the form properties instead. serouche Ravikumar_Tadi wrote: 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
Re: Help On Deleting Record
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
Re: Help On Deleting Record
Hi Ravi, Instead of '$Create Date$ ($TIMESTAMP$ - 604800)' try to give the entry id or request id of that schema. Thanks, Suddha On 3/28/07, Ravikumar_Tadi [EMAIL PROTECTED] wrote: 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
Re: Help On Deleting Record
If you already have the EntryID you can use the Run Process command of Application-Delete-Entry $SCHEMA$ $1$ If you are searching for records to delete (i.e. deleting child records in another form) put the qualification inside a set of parenthesis like this Application-Query-Delete-Entry $SCHEMA$ ( 'Create Date' ($TIMESTAMP$ - 604800)) Think of the qualification as what you would put in the Advanced Search bar on the form and then just put () around it. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravikumar_Tadi Sent: Wednesday, March 28, 2007 3:09 AM To: arslist@ARSLIST.ORG Subject: Help On Deleting Record 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
Re: Help On Deleting Record
Hi All, I am using Application-Delete-Entry $SCHEMA$ $1$ On event Delete on $SCHEMA$ I initiate, if necessary, a new delete is started in other forms. Regards, Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, March 28, 2007 4:40 PM To: arslist@ARSLIST.ORG Subject: Re: Help On Deleting Record If you already have the EntryID you can use the Run Process command of Application-Delete-Entry $SCHEMA$ $1$ If you are searching for records to delete (i.e. deleting child records in another form) put the qualification inside a set of parenthesis like this Application-Query-Delete-Entry $SCHEMA$ ( 'Create Date' ($TIMESTAMP$ - 604800)) Think of the qualification as what you would put in the Advanced Search bar on the form and then just put () around it. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ravikumar_Tadi Sent: Wednesday, March 28, 2007 3:09 AM To: arslist@ARSLIST.ORG Subject: Help On Deleting Record 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 -- *DISCLAIMER* The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *END OF DISCLAIMER* ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Help On Deleting Record
You didn't specify what version of AR System you are using. I don't remember exactly which version included archiving , but if you have a version that supports archiving that is an easier way to accomplish this task. One of the options in the archive is to just delete the records. Ravikumar_Tadi [EMAIL PROTECTED] Mar 28, 2007 2:09 AM 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