LOTUSSCRIPT/COM/OLE CLASSES
Examples: Search method
1. This script uses @IsResponseDoc to get a collection of all the response documents in a database that were created or modified after May 1, 2000.
Dim db As New NotesDatabase("Katmandu","somedocs.nsf")
Dim collection As NotesDocumentCollection
Dim dateTime As New NotesDateTime(_
Cstr(Datenumber(2000, 5, 1)))
Set collection = db.Search("@IsResponseDoc",dateTime,0)
2. This script uses @IsResponseDoc to get a collection of all the response documents in a database.
Dim db As New NotesDatabase("Katmandu","somedocs.nsf")
Dim collection As NotesDocumentCollection
Set collection = db.Search("@IsResponseDoc",Nothing,0)
3. This script reminds project participants of their due date by mailing them a Project document from a database. The ReminderDate item on each document is used to indicate when a reminder should be sent. The Search method gets all Project documents for which the ReminderDate item is set to today, mails the document, and updates the ReminderDate field to one week later.
Sub Initialize
Dim session As New NotesSession
Dim db As NotesDatabase
Dim collection As NotesDocumentCollection
Dim doc As NotesDocument
Dim dateTime As New NotesDateTime(_
Cstr(Datenumber(2000, 5, 1)))
Dim nextDateTime As NotesDateTime
searchFormula$ = {Form = "Project" & ReminderDate = @Today}
Set db = session.CurrentDatabase
Set collection = db.Search(searchFormula$, dateTime,0)
Set doc = collection.GetFirstDocument()
Set nextDateTime = New NotesDateTime("Today")
Call nextDateTime.AdjustDay(7)
While Not(doc Is Nothing)
Call doc.Send( True )
Call doc.ReplaceItemValue("ReminderDate", _
nextDateTime.LSLocalTime )
Call doc.Save( True, False )
Set doc = collection.GetNextDocument(doc)
Wend
End Sub
See Also
Search method
Glossary
Help on Help
Open Full Help Window
Glossary
Help on Help
Open Full Help Window