Random documents need to be modified and saved again before appearing in view

I have tried searching on this forum and looking through the FAQs but I can’t seem to find a fix for this problem.

I am maintaining a Document Library on Notes 6.5 and I have had complaints from users submitting their documents. The ‘normal’ flow of things would be that a user clicks on a button to request a document number. the number is generated from a view and it displays the number to the user in a messagebox as well as send the number by mail. The user should then be able to look in a ‘My Reports’ view which has a selection of ‘SELECT @All & Form=“Document” & Names=@Name([CN];@UserName)’. The document also appears in the ‘All Documents’ view.

The problem is that, every so often, users would complain about not being able to view the document in My Reports view but the document is there in ‘All Documents’.What we found out is that by opening the document from the ‘All documents’ view, arbitrarily editing some fields and saving it again, it would then appear in the ‘My reports’ view normally.

I’ll try to give as much detail as possible : This is not a user specific problem as it could happen randomly. The ‘disappearing’ documents disappear from everyone’s view, not just from a specific user. The view is of type shared,private on first use.

No one else designs or modifies the code except me currently. Does this problem have to do with a cache? The library uses 581 meg of disk space and contains 10,479 documents and is at most 2 years old. Do I need to run some maintenance code on the server?

Thanks in advance, anyone!

Subject: Random documents need to be modified and saved again before appearing in view

First don’t use @Username in your view selection formula.The way you have it set up…documents will disappear, view performance is very slow.My suggestion,remove the Names =@Username in the selection formula and have readers fields in the documents with the user name and then you can show the documents in the view without any problem.

Subject: RE: Random documents need to be modified and saved again before appearing in view

While this may solve the issue for the @username selection formula and shared,private on first use view, what about other views?

I did not mention in my previous post, but this problem also occurs in other views where the selection formula has nothing to do with @username.One user was searching in all other views for a particular document but couldn’t find it. Found it in ‘All documents’, modified and saved some fields before it started to appear in other standard views too. Why is that so?