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.***
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
