Yes, I think at the very least it would contrary to the spirit of the license agreement to change submitter field with SQL, if the mode was locked. Our mode is currently changeable, so I would just need to be sure we didn't do that in the past! It seems unlikely.
Thanks, L. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, July 11, 2007 12:23 PM To: arslist@ARSLIST.ORG Subject: 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 __20060125_______________________This posting was submitted with HTML in it___ 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"