Functions for document set fields

This function applies to the document fields of type number, date, and string. This function compares the document set meta field across several documents of a specific type and returns true if they are unique. You can also specify a minimum number of documents required to satisfy the specified criterion.

The syntax for this function is: Unique(Document Set Field, operator, value, number of documents)

It includes four parameters.

First Parameter	Second Parameter	Third Parameter	Fourth Parameter
Includes the document set meta data field.	Includes one of the comparison operators: >, <, >=, <=, != ,= For a string parameter, the supported operators are != and =. This operator should be passed in quotes.	Includes a process variable, static value, or a function. The type of this parameter must match with the first parameter.	Includes the number of documents that are required to satisfy a criterion.

For example, the Quantity field in a document type (product) has the following values: 100,200,200,200,500.

1. Unique (Quantity, ">",50, 3) returns true because there are three documents that match the criteria, and the values are unique.

2. Unique (Quantity, ">", 50, 2) returns true because there are two documents that match the criteria, and the values are unique.

3. Unique (Quantity, ">",50, 5) returns false because there are only three documents that match the criteria, and the values are unique.

4. Unique (Quantity, ">",50, 0) returns false because all records must be unique.

This function compares a document set meta field across several documents of a specific type and returns true if there is a match.

The syntax for this function is: Match(Document Set Field, operator, value, number of documents)

For example, the Quantity field in a document type (product) has the following values: 100,200,200, 200,500.

1. Match (Quantity, "=", 200, 3) returns true because a minimum of three documents in the set have the same values.

2. Match (Quantity, "=", 200, 2) returns true as there are at least two documents that match the criteria, and the values in those documents are the same.

3. Match (Quantity, "=", 200, 5) returns false because a minimum of five documents should match the values.

4. Match (Quantity, "=", 200, 0) returns false because all documents should match the values.