Refresh View using Lotusscript
Posted on 2007-08-09
I have an import from excel to lotus notes agent.
The agent import fields to the document and it does a lot of test date calculations
There is a specific view in the db which I urgent need to refresh after the import using the same LS agent as it does the recomputation of all the computed fields that I need on the doc and which are the basis of all the reports in the db.
Using an action in the view with @command([toolsrefreshalldocs]) and @command([toolsrefreshselecteddocd]); IS NOT AN OPTION
I know that I can create a scheduled agent to run in the background which has @command([toolsrefreshalldocs]) THAT ALSO IS NOT AN OPTION as the users may decide to import and directly extract a report from db which requires that the view is refresh
Its a very large db with over 100,000 docs.
In the script agent, I do have call view.refresh and uiw.viewrefresh but this works OK for currently open view, however, the view that Urgently needs refresh is not the currently open view during the import
Any help will be greatly appreciated