HCL Domino - Examples: SELECT - 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

FORMULA LANGUAGE

Examples: SELECT
1. You want to change the contents of the Status field in several documents to Closed. However, you do not want to change the Status field of any document that contains the value Unsigned Contracts in the Categories field.

To make the desired change, you write and run an agent that runs a formula. When you write the formula, you specify the documents that you want Lotus Notes/Domino to scan to make the change. By adding a SELECT statement to the formula, you can further limit the documents that Lotus Notes/Domino looks at when you run the agent.

SELECT Categories != "Unsigned Contracts"; FIELD Status := "Closed";

2. This replication formula limits replication to documents that contain a Year field whose value is greater than 1995.

SELECT @IsAvailable(Year) & Year > 1995

3. This replication formula limits replication to documents that do not contain a Year field or whose Year field is greater than 1995.

SELECT !@IsAvailable(Year) | Year > 1995

See Also

SELECT

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Feedback on Help or Usability?

Help on Help

All Help Contents