to update all those private views by instructing users on deleting them then
re-creating them...
Well, after doing a project for a large government agency who doesn't want
their users using views (... I know, strange!) but everything had to be build
with dialog boxes and some intense Lotuscript. I came across a interesting bit
of info. If you create a private on first use view complete with @UserName in
the selection formula, the code (and indirectly, the user) can access the view
with GetAllDocumentsByKey and GetDocumentByKey calls without the actual private
view from being built at all. This dramatically increases speed from doing an
FTSearch or looping through several documents. And updating this semi-private
view is a snap since the private view is actually never built.
Actually any NotesView lookup method works here:
Dim session As New NotesSession
Dim db As NotesDatabase
Dim view As NotesView
Dim dc As NotesDocumentCollection
Set db = session.CurrentDatabase
Set view = db.GetView( "MyOpenDocuments" )
Set dc = view.GetAllDocumentsByKey("Open", True)
If dc.count <> 0 Then
Msgbox "You have " & dc.count & " open documents to process today."
Else
Msgbox "You do not have any open documents to process today."
End If
Requires Free Membership to View
Register today to access targeted resources from our editorial writers and independent industry experts focused on Lotus Domino, Notes, Workplace and other related technologies.
This was first published in November 2000