Reputation: 525
I have a Lotus Notes database in which a view shows up empty, BUT when i do a search (using basic notes search functionality), it returns some documents. How can this be possible? Also how to make those documents show up in the view.
I tried updating the Readers field of the documents, but that also didn't worked.
Please help.
Upvotes: 0
Views: 8961
Reputation: 3524
There is very high probability your view shows response documents, but not their parent/main document. Response hierarchy is ignored after FT search, therefore they show up.
Simply, turn off "Show response documents in a hierarchy" in view properties or rewrite selection formula.
Upvotes: 4
Reputation: 9349
First check if the view is actually empty. You could have documents in the view, but because they don't have fields that match the columns they won't be visible.
Double click on a blank spot where a document should be, or CTRL-A (Select All). Alternatively page down a number of times, as the documents you are finding may be lower down.
I would recommend then to check the Search criteria of the view in question that you are not accidentally pulling in documents that are not meant for that view.
If that doesn't work (which I have never seen to be honest), the full text index search works as follows.
Make a call to the FTI folder with the search term.
Gets a list of documents that match the search.
Discards the documents on that list based on the following.
It then displays those documents in the view.
So in short, the full text index search will never show documents that cannot already be shown in the view.
Beyond that, a possible corrupted view index. You can run "UPDALL -v" on it to rebuild the indexes.
Upvotes: 1