Doug,
I completely forgot about possible DIRECT SQL commands. I'll add them to my list of things to check. Also I'll take a look at the filter_set.... tables too. I know there are many push actions which create new records. They aren't a problem, but sorting out the new record push actions from any that might attempt to update an existing record is my concern. Thanks Leigh ________________________________ From: Anderson, Douglas W. [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 11:54 AM To: listmembers- arslist Cc: Leigh Gruber Subject: Re: Submitter Mode - Locked ...Brute force? Hi Leigh, You ought to be able to determine whether workflow modifies a Submitter field's contents by querying the ARS database. Run SQL queries against the filter_set, filter_push, actlink_set, and actlink_push tables to see whether fieldId 2 (Submitter) is the object of any set-field or push-field actions. The escalation actions are stored along with the filter actions, so you'll get 2-for-one there. That would not catch any direct-SQL modifications to Submitter, but I am not certain that having submitter mode = locked prevents those anyway. HTH, Doug Anderson Mayo Clinic Rochester, MN Opinions expressed are necessarily mine, not necessarily those of the Mayo Foundation. Original message: Date: Wed, 11 Jul 2007 10:17:44 -0400 From: Leigh Gruber <[EMAIL PROTECTED]> Subject: Submitter Mode - Locked ...Brute force? Good Morning Listers, We have an existing system operating with the Submitter Mode set to Changeable. This system has around 750 forms with a mix of Remedy and home grown applications. We need to change submitter mode to Locked so we can host another custom application which must run in Submitter Mode Locked. I have 3 questions! 1. Is there any way, other than ones that require "brute force", to determine if the original system has workflow that modifies the submitter field? I have set the development box to Submitter Mode locked and tried some very limited record modification, but I don't have any testing resources available. <snip> I would appreciate any words of wisdom you might have for me. Many thanks, Leigh Gruber The information contained in this message may be privileged and/or confidential. If you are not the intended recipient, or responsible for delivering this message to the intended recipient, any review, forwarding, dissemination, distribution or copying of this communication or any attachment(s) is strictly prohibited. If you have received this message in error, please so notify the sender immediately, and delete it and all attachments from your computer and network. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
