Home
HCL Domino Designer Basic User Guide and Reference
This guide provides information on using HCL Domino Designer and programming language reference information.
Programming Overview and User Interface
This section contains general guidelines and examples that show where to use Java, LotusScript, and the formula language.
Programming Overview
This documentation describes how to attach Java, JavaScript, LotusScript, and formula code to Domino design elements. Here are some overview topics:
Form, selection, and column formulas
Selection formulas
A selection formula selects the documents that appear in a view.
Examples: Selection formulas

Examples: Selection formulas

The default selection formula for a database is:
```
SELECT @All
```
This formula selects only documents based on the "Main" or "First response" form:
```
SELECT Form="Main" | Form="First response"
```
These examples are from the mail template mail.ntf. The first example is the selection formula for the Drafts By Category view; the documents selected for this view are those where both the DeliveredDate and PostedDate are not filled in (are null). The second example is the selection formula for the Sent By Category; the documents selected for this view are those where the PostedDate is filled in, but the DeliveredDate is not. The third example is the selection formula for the Received By Category view; in this case, either the DeliveredDate or the Date field is filled in.
```
SELECT DeliveredDate = "" & PostedDate = ""
SELECT DeliveredDate = "" & PostedDate != ""
SELECT DeliveredDate != "" | Date != ""
```