IBM Lotus Domino Designer 8.5
  Versions 8.5 and 8.5.1

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

---

Library | Support | Terms of use |

Last updated: Monday, October 5, 2009