Re: Submitter Mode - Locked ...Brute force?I do not think it would catch Direct SQL commands as an SQL statement in a Direct SQL command is not evaluated by the ARS before its passed to the DB for execution. You could pretty much type Hello and pass that to SQL and it would error only at the time of execution.
However if you try to change the submitter value using Direct SQL, the database server would not return a valid SQL statement as an error and hence I am pretty certain it would execute.. Whether you are or not ALLOWED to do that without breaking a license agreement, I am not certain. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Anderson, Douglas W. Sent: Wednesday, July 11, 2007 11:54 AM To: arslist@ARSLIST.ORG 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 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.2/894 - Release Date: 7/10/2007 5:44 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
