View not updating

HCL Domino Domino Forum
1

In form(a)the user manually updates three fields that are dblookups from a view showing all the docs created by form(b). There is an unique identifyer for each doc so the db lookup only returns one value for each field. On Save A lotuscript updates the three fields in the original document. If the user wants to add another update to the same document the previosly ammended data does not show for about 5 to ten minutes. An embedded view shows the changes but a dblookup doesnt. I have tried @command([ViewRefreshFields]), view.refresh, workspace.refresh & workspace.reload methods but nothing makes any differernce. shift F9 on the view doesn’t work or Ctrl Shift F9 for that matter. How can I get the change to be immediate to the dblookups. They are set to NoCache. the db is update immediately and views are Autonatic index and refresh. What else Can I do.Mark

Please help!

2

Subject: view not updating

I know this is an old thread, but I was having the same problem and just found the answer. Try using “ReCache” in the cache parameter in your @DbLookup. This is new to ND6, but worked for me. Good luck.

3

Subject: view not updating

Let me check if I understood.

The three fields you are updating are key fields in a view (used by dblookup), then when you change any of that fields, you cannot find the document immediately, you have to wait up 10 minutes.

If I’m right, I can say you I had same problem and I solved with LS:

Call DocModified.Save(True, False)

Call View.Refresh

If you tried this method, then you can check:

  1. The Update task is working in the server. This task update automatically all view indexes.

  2. The view index is not corrupt. Try to rebuild the view index, typing in the server console:

load updall dbName -R

  1. Obviously, we are assuming, your server is not very busy, and your actual update task is enough to manage all the work.

Let me know your results.

4

Subject: RE: view not updating

Thanks for your response.You are nearly correct with your understanding. Except it is not that the document doesnot appear for ten minutes, it is that the dblookup does not bring the modified values back for ten minutes, even though I can see them there in an embedded view. The dblookup still brings back the old values. I have tried your suggestions but none of them cure the problem. Any other ideas?

Mark

5

Subject: RE: view not updating

Ok, I dont know if you are using the Notes client or a web browser, in case you are using a web browser then you can:

  1. Upgrade your web browser to the latest realese

  2. Tell to your web browser to update the page “every visit to the page”

  3. Delete the browser cache

  4. Try again

6

Subject: RE: view not updating

unfortunately its the client I am using

7

Subject: view not updating

What about changing the “On Save” LotusScript to force a view refresh via LotusScript, i.e. view.Refresh ?