FORMULA LANGUAGE
The SELECT reserved word defines criteria for the selection of documents in an agent that runs a formula, in a view, or during replication. You use a SELECT statement before an expression to define the set of documents that you want to change, see in a view, or replicate.
Syntax
SELECT formula ;
Usage
The word SELECT is automatically prepended to the view selection formula when the formula is saved.
Use SELECT @All to select all documents for an operation (for example, use it in the selection formula for a view that displays all of the database's documents). @All should never be used without the SELECT reserved word. If your formula contains @All by itself, Lotus Notes/Domino appends the SELECT @All statement to your formula:
@All; SELECT @All;
If you compare a field to a value (for example, Year > 1995) and the field is unavailable, the comparison is false. However, you should check for fields that may not be present with @IsUnavailable.
This reserved word does not work in column, hide-when, section editor, window title, hotspot, field, form, or form action formulas.
SELECT is not intended for use in toolbar buttons.
Language cross-reference
SelectionFormula property of LotusScript NotesView class
Example See Also