HCL Domino - Examples: Selection formulas - Need a Domino Consultant? Call NotesMail +1 212-599-2048

HCLSoftware Business Partner Domino Consulting Services CRUCIAL Notes Tools +1 212-599-2048	Domino Consulting Services CRUCIAL Notes Tools Domino administration Notes development	Chat now
.

Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

PROGRAMMING OVERVIEW AND USER INTERFACE

Examples: Selection formulas
1. The default selection formula for a database is:

SELECT @All

2. This formula selects only documents based on the "Main" or "First response" form:

SELECT Form="Main" | Form="First response"

3. 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 != ""

See Also

Selection formulas

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Feedback on Help or Usability?

Help on Help

All Help Contents