Just a thought on that though. I in the past also preferred the set a field and have filter do the delete, but think about this. If you do an 'Application-Delete-Entry' run process, the only workflow that fires on the affected record is that that is set to fire on delete. If you do a setfield on the record and use a filter, ALL filter workflow that fires on modify of that record fires, thus increasing the load on your App server, in addition to that, being the delete occurs in phase 3 of processing you will be executing all of the SQL to update the last mod by and last mod date of the record for each record affected, thus increasing the load on the db server. Simply deleting the record with a delete process is cleaner, crisper and eliminates load on the app and db server....just something to think about.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, January 21, 2010 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: Delete entry Since it is on the right side of the equation and not using any fields from the form the Escalation should only do the calculation once. As for setting a field and having a Filter do the delete, that is my preferred method as well Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, January 21, 2010 10:51 AM To: arslist@ARSLIST.ORG Subject: Re: Delete entry ** John, Should work but I'd make the process a little more data driven.. Instead of having the escalation calculate all this and chocking an escalation thread, I'd set that delete time to a temp field at the time of submitting the record. For e.g.. create a temp field called ztmpDeleteTime. Set the time $TIMESTAMP$ + 86400 to it using a filter.. Then have the Escalation check 'ztmpDeleteTime' < $TIMESTAMP$ and mark the record for deletion using another temp field that you have that escalation set say 'ztmpDelete' to Y.. Do not have the escalation delete it again for the purpose of not choking the escalation thread. Have a filter that performs that delete when the record is marked for deletion and the $USER$ is the escalation user. It would be more efficient especially over a large number of records.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of John Kelley Sent: Thursday, January 21, 2010 11:39 AM To: arslist@ARSLIST.ORG Subject: Delete entry Hi All Brain cramp today Can someone confirm that this statement is true! I am performing a delete action in an escalation for deleting all items in a form 24 hours and beyond. Let me rephrase I want to leave items in the form for 24 hours from the submit date. 'Submit Date' < ( $TIMESTAMP$ - 86400) Sys:Action ARS 7.1 Thanks JK ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
