Thanks for the advise! David M.
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Friday, May 30, 2008 12:38 PM To: [email protected] Subject: Re: Tables not refreshing "On Open" ** If the AL is only running on Display, won't the $OPERATION$ value always be "SET"? By the way, if your table is on a tab, I'd recommend turning OFF the "Refresh On Entry Change" setting. A lot of the performance issues with forms displaying stem from tables that no one is looking at being refreshed when the form opens. To make sure the table gets refreshed as needed: 1. Set the AL to run on "Display" AND "Gain Focus" of the tab its on. No need to have it refresh on Window Open or Window Loaded. 2. Give it a Run If of 'Page holder' = "Tab Name" 3. Action: Refresh the table. That structure makes sure you only refresh the table when needed. It used to take our Help Desk form up to 30 seconds just to display a record because of all the hidden table refreshes that were happening. Now its less than 1 second. Hopefully that helps some. Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach Carey Matthew Black <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 05/30/2008 09:21 AM Please respond to [email protected] To [email protected] cc Subject Re: Tables not refreshing "On Open" David, I suggest that you change the execute on condition to "Display" and you might want to add $OPERATION$= "SET" (to only refresh the tables when your looking at a data row) to the Run If. (If it is not already there.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Fri, May 30, 2008 at 12:13 PM, Morrison, David A. <[EMAIL PROTECTED]> wrote: > ** > > Only condition is Window Open. Thanks for replying. > > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook > Sent: Friday, May 30, 2008 12:04 PM > To: [email protected] > Subject: Re: Tables not refreshing "On Open" > > > > ** David, what are the firing conditions on this Active Link? > > Rick > > On Fri, May 30, 2008 at 8:56 AM, Morrison, David A. <[EMAIL PROTECTED]> > wrote: > > Good day everybody, > > Strange problem that is driving me nuts. I have an Active Link that has > as one of its actions a Change Field on a table with the option being > "Refresh Table". The worklog says the qualification passes and lists > the action, but the table does not refresh when the form opens. Only > one view and all permissions have been checked. Any ideas would be > greatly appreciated. > > AR 7.1 patch 2 > Windows Server 2003 > SQL 2005 > > > David Morrison > East Tennessee State University ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
