FORMULA LANGUAGE


SELECT
Example

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


Using SELECT in the formula eliminates the need to go through the database to select the documents. You can run the filter macro on all the documents in the database, and the SELECT statement performs the selection process.

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