Topics

Use the "Selection Formula" field in a Directory Catalog Configuration document to enter a selection formula to aggregate only documents defined by the formula. For example, to aggregate only Person documents with a value of "Atlanta" in the Location field, aggregate all Group documents, and exclude all other documents, use the following selection formula:

SELECT (Form = "Person" & Location = "Atlanta") | (Form = "Group")

Or to aggregate only Person documents for people assigned to a specific mail server, use a selection formula such as:

SELECT (Form = "Person" & MailServer = "MailServer1")

The "Selection Formula" field functions similarly to the replication setting "Replicate a subset of documents - select by formula" option used in other databases. Keep in mind that a selection formula applies to all the aggregated directories, so make sure it is valid for all of them. Note that you can't use a selection formula to aggregate documents that are never aggregated into a directory catalog. For example, you can't use a selection formula to aggregate Server Configuration documents or Server Connection documents.

For more information on selection formulas, see the topic "Selection formulas" in Domino Designer Help.

How a selection formula interacts with the "Group types" setting
The "Group types" field in a Directory Catalog Configuration document controls the types of groups that the Dircat task aggregates into a directory catalog. If you use a selection formula and you want to aggregate groups, you must select the groups as part of the selection formula and use the "Group types" field to indicate which types of groups to aggregate. For example, if you want to aggregate only Person documents with a Location of Atlanta, and only Mail and Multipurpose groups:

 Use this selection formula: SELECT (Form = "Person" & Location = "Atlanta") | (Form = "Group")
 Select the "Group Type" option "Mail and Multipurpose."

A selection formula can select only the types of groups indicated by the "Group types" option.

How a selection formula interacts with the "Include Servers" setting
The "Include Servers" field in an Directory Catalog Configuration document for an Extended Server Directory Catalog controls whether the Dircat task aggregate Server documents. If you use a selection formula and you want to aggregate Server documents, you must select the Server documents as part of the selection formula and check the "Include Servers" field.

You cannot aggregate Server documents into a Mobile Directory Catalog/Condensed Server Directory Catalog.

How a selection formula interacts with the "Include Mail-In Databases" setting
The "Include Mail-In Databases" field in a Directory Catalog Configuration document controls whether to aggregate Mail-In Database documents. If you use a selection formula and you want to aggregate Mail-In Database documents, you must select the Mail-In Database documents as part of the selection formula and select Yes for the "Include Mail-In Databases" setting.