How to fix indexing issue when 'Private and Shared on First Use View' is being used?
Posted on 2011-03-14
The view 'vwAcc' is 'Shared and Private on first Use' . The Selection formula used is SELECT ((Form = "Account Profile")) & isbkp !="Yes" & (@Contains(@Name([CN];Author);@Name([CN];@UserName)) | @Contains(@Name([CN];Author1);@Name([CN];@UserName)))
The code is used -- Set picklist = workspace.PickListCollection( PICKLIST_CUSTOM,False, db.Server,db.FilePath,"vwAcc", _
"Document picker", "Please select one Profile, to create checklist.")
Issue is - This view is empty at times for the user. When we use 'Shift+F9' the index is rebuilt and the documents are populated. Surprisingly, its working fine for me on the Development copy but for a few users across locations this is a major issue.
Can anyone suggest how to avoid this issue? Without using 'Shift+F9' the view must populate all the documents. If a design change has to be made so as not to use the 'Private and Shared view' please do let me know.