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
Glossary
Feedback on
Help
or
Product Usability
?
Help on Help
All Help Contents
Glossary