Thanks everyone for your responses. Personally I prefer to go with the Perform-Action-Apply when saving the current window. Maybe because it is newer.
Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Thursday, December 08, 2011 10:28 PM To: arslist@ARSLIST.ORG Subject: Re: Commit Changes vs PERFORM ACTION APPLY ** True Commit Changes does that too, though personally I have started to use the Perform-Action-Apply for creating workflow for submits and searches as soon as it got available in version 6.3 I think.. Commit Changes should not however be confused with the ‘commit transaction’ in T-SQL or a ‘commit’ in Oracle as was by Mark following his SQL – at least that was my understanding of what he was attempting to do.... A Direct SQL once run from the Direct SQL action, is automatically followed by a commit when necessary. Joe From: LJ LongWing<mailto:lj.longw...@gmail.com> Sent: Thursday, December 08, 2011 5:32 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Commit Changes vs PERFORM ACTION APPLY ** Joe….that is ‘one’ of the things the Commit Changes does….when you are NOT in a dialog window, for example in a search window, the commit changes action performs the search, if in a submit window, it creates the record…if in a modify window it saves changes…so I think they ‘kinda do the same thing’ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Thursday, December 08, 2011 2:55 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Commit Changes vs PERFORM ACTION APPLY ** If you have a direct SQL query in your workflow, you do not need to use either of these after the Query. The AR Server performs the commit after the successful execution of that query wherever a commit is required (in case of insert, update or delete). Perform-Action-Apply is used for submitting in a submit or modify window and search in a search window while commit changes is used to push the values from a child window in a dialog box operation to the parent window after the child is closed, on fields where there was a mapping on window close between the parent and child window.. Joe From: Brittain, Mark<mailto:mbritt...@navisite.com> Sent: Thursday, December 08, 2011 3:51 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Commit Changes vs PERFORM ACTION APPLY ** HI All, Commit Changes vs. PERFORM ACTION APPLY. Is one better to use than the other on ARS 6.3? I have one active link that populates data from a SQL query and a second active link to commit the changes. These were probably created under ARS 3 or 4. The Commit Changes does the job but always looking to smart way to do things. Thanks Mark Mark Brittain Remedy Developer NaviSite – A Time Warner Cable Company mbritt...@navisite.com<mailto:mbritt...@navisite.com> Office: 315-453-2912 x5335 Mobile: 315-317-2897 ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"