Given selection criteria for a document, returns all documents in a database that meet the criteria.
public DocumentCollection search(String formula)
throws NotesException
public DocumentCollection search(String formula, DateTime dt)
throws NotesException
public DocumentCollection search(String formula, DateTime dt, int max)
throws NotesException
String formula
A Notes @function formula that specifies the selection criteria.
DateTime dt
A cutoff date. The method searches only documents created or modified since the cutoff date. Can be null to indicate no cutoff date.
int max
The maximum number of documents you want returned. Specify 0 to receive all matching documents (up to 5,000. See Usage section.).
DocumentCollection
An unsorted collection of documents that match the selection criteria.
This method returns a maximum of 5,000 documents by default. The Notes.ini variable FT_MAX_SEARCH_RESULTS overrides this limit for indexed databases or databases that are not indexed but that are running an agent on the client. For a database that is not indexed and is running in an agent on the server, you must set the TEMP_INDEX_MAX_DOC Notes.ini variable as well. The absolute maximum is 2,147,483,647.
Search method in LotusScript NotesDatabase class
EditSelectByDate @command of formula language
See examples