When using a Notes client, some documents fail to appear in a view. But when I use Designer to look at the view, the documents all show.
I don’t see any reason for this. The documents meet the view selection criteria. There is a Reader field valued with 2 roles, but I have Manager access with both roles. They should be showing in Notes, just like they do in Designer. Why the difference?
Subject: Documents show in view using Designer, but not using Notes
I always keep an “AllDocs” view- by order of input- w/ Form, Modified by columns- if I can’t see them there, it is a rights issue- if I can, than I have something in a view selection formula (generally a problem with name normalization) thing.
Subject: SOLUTION - Documents show in view using Designer, but not using Notes
The view needed to be “rebuilt.”
I just work on the developer side, and this is apparently something done on the server side that I’m not familiar with. But it solved the problem.
(As Tammy pointed out above, simply making a copy of the view and renaming it to replace the “corrupt” view also works.)
Thanks to everyone for their help!
Subject: RE: SOLUTION - Documents show in view using Designer, but not using Notes
Rebuilding a view (index is that) is (or at least should) be no different from pressing Shift+F9 (if you have appropriate rights to the database).
Subject: Documents show in view using Designer, but not using Notes
I have seen this in my shop too… It has always been a view that was working correctly before but for some reason ceased to show all the documents in the client that were showing in designer… After doing several things I finally just copied the view. The new copy would work fine and then delete old copy and rename copy to old name. Hope this helps.
Subject: RE: Documents show in view using Designer, but not using Notes
Oddly enough, that does work. Thanks, Tammy!
But I’m still curious what’s going on.
Subject: RE: Documents show in view using Designer, but not using Notes
Sometimes, when you edit a view, the client can get confused and display a blank screen or one full of replication conflicts (when there aren’t really an conflict docs). If you close all windows of database (including in Designer) and reopen, that will generally fix the problem. Or, press Shift+F9 while in the view.
Subject: RE: Documents show in view using Designer, but not using Notes
This view has not been recently edited, and multiple users report that the same documents have been “missing” for about a month (with daily restarts of Notes). The screen is not blank and has no conflicts. Refreshing has no effect.
Subject: RE: Documents show in view using Designer, but not using Notes
Just out of curiosity: Has this view the option to allow user modification set (default for new views)?
If so, I’d be interested to know, if resetting the view to defaults (from the view menu) makes any difference (if you still have the faulty view).
Subject: RE: Documents show in view using Designer, but not using Notes
Interesting idea, but customizations are not allowed for this view.
Subject: RE: Documents show in view using Designer, but not using Notes
Are you maybe using @Return in any of the column formulas? There may be something about one of the columns that’s causing confusion to the indexer. Copy the view and delete columns from the copy one by one and see whether the problem goes away.
Subject: RE: Documents show in view using Designer, but not using Notes
There is no @Return statement in the column formulas.
There are only 2 columns in this view. One just references a field, and the other uses a @ReplaceSubstring formula.
Subject: RE: Documents show in view using Designer, but not using Notes
Is the view set to display documents hierarchically? Could it be that the documents that are not showing up are response documents? Find a document that should show up in the view and doesn’t. Compare it item by item with one that is in the view. Any differences that might be important? Readers fields, $Conflict or $Ref, items of different datatypes?
If you make a copy of the view, does the copy show the same documents as the original? If you change the formulas in the columns to something non-challenging like a simple fieldname, does that affect the number of documents visible? Does the selection formula use a name which is also the programmatic name of a column, and does that column contain something other than a simple field reference?