Hi all,
Why the refresh icon keep showing in the upper left corner of the View although there is no new document? How to disable it?
Thanks.
Subject: The “refresh icon” keeps showing in View.
Check the selection formula, it probably includes something like
SELECT Form=“x” & @Date(SomeField) >= @Yesterday
Using @Today, @Tomorrow, @Yesterday or @Now in a view selection is an extremely bad practice. These formulas return a different value from one moment to the next, so the view index can never be considered up to date. Hence the refresh icon.
Happily, R6 makes view selection formulas read-write, meaning you can modify them via an agent. So, when you need to capture documents where, for example, some date value falls in the last three days, you can schedule an agent to run once a day and hard-code the necessary date text in the selection. The script would look something like this:
dim s as notessession
dim db as notesdatabase
dim view as notesview
dim dt as notesdatetime
set s = new notessession
set db = s.currentdatabase
set view = db.getview(“someview”)
set dt = new notesdatetime(“Today”)
call dt.adjustday(-3)
view.selectionformula = “SELECT Form=”“x”" & SomeField >=[“+dt.LSLocalTime+”]"
Run that agent once a day just after midnight.
The same agent can also modify column titles, for example “Documents created on or after 2/01/2004”
Subject: The “refresh icon” keeps showing in View.
Depends on the view; this is usually a sign that the view has some date-sensitive formula in it (either in column or view selection code). This dodgy coding practice means that the server is constantly re-evaluating the view, hence the “permanent” refresh icon.
–