IN Predicate

The 'Property Name' property determines which field from the CMIS Repository will be evaluated by the predicate.

• Select a property from the drop-down list, which includes all queryable properties for the current content type.
• The property name must match the query name as defined in the repository schema.
• If the property is not queryable, a validation error will be reported.

Usage

Use this property to select the field whose value you want to match against a list of allowed values.

Example

To filter for files with specific extensions, set 'Property Name' to FileExtension.

Changing this property affects which data is compared and may impact the valid types and formatting for the 'Values' property.

The 'Values' property defines the set of values that the selected property must match for an item to be included in the query results.

• Enter one value per line.
• Enter one or more values appropriate for the property's data type.
• For String, DateTime, URI, or ID properties, values must be enclosed in single quotes (e.g., '.pdf', '2023-01-01').
• For Integer and Decimal properties, values should be unquoted (e.g., 10100, 42.5).
• Boolean properties are not supported for IN Predicate.

Usage

Use this property to specify all acceptable values for the selected property. The predicate will match if the property's value equals any value in this list.

Examples

• To match files with certain extensions: ('.pdf', '.docx', '.xlsx')
• To match specific status codes: (10100, 10200, 10400)
• To match specific dates: ('12/01/2018', '12/02/2018')

Changing this property directly affects which items are included in the query results. Ensure that the values are formatted and quoted correctly for the property type.

The 'Not' property allows you to invert the logic of any Where Predicate. When enabled, the predicate will match items that do not satisfy the specified condition or group of conditions.

• Set to true to invert the predicate (apply logical NOT).
• Set to false to use the predicate as defined.

Usage

Use this property to exclude items that would otherwise match the predicate, or to invert complex groups of conditions.

Examples

• To find all documents that are not PDF files: WHERE NOT FileExtension = '.pdf'
• To find all items that do not match a group of conditions: WHERE NOT (FileExtension = '.pdf' OR FileExtension = '.docx')

Changing this property reverses the inclusion logic for the predicate or group, directly affecting which items are returned by the query.