│ Grooper Help - Version 25.0
25.0.0017 2,127
  • Overview
  • Help Status

Predicate List

Where Predicate Grooper.CMIS

Defines a collection of search conditions to be evaluated as a group using a logical operator (AND/OR).

Remarks

The Predicate List is used to group multiple Where Predicates in a CMISQL Query and evaluate them together using a logical operator. This enables the construction of complex WHERE clauses that combine multiple conditions with either AND (all must be true) or OR (any may be true).

The logical operator is set using the 'Logical Operator' property and determines how the contained expressions are combined.

Usage

  • Use the Predicate List to group related conditions in your WHERE clause.
  • Set the 'Logical Operator' to "AND" to require all conditions to be true, or "OR" to require at least one condition to be true.
  • Add one or more Where Predicates to the 'Expressions' property to define the conditions to be evaluated.

Examples

The following will return both PDF and Microsoft Word files in the result set: (FileExtension='.pdf' OR FileExtension='.docx')

The following will return PDF files which have a size greater than 100,000 bytes: (cmis:contentStreamLength>100000 AND FileExtension='.pdf')

The Predicate List is essential for building advanced queries that require multiple conditions to be evaluated together. It supports nesting, so you can create groups within groups for even more complex logic. When configuring a Predicate List, ensure that the logical operator and contained expressions accurately reflect the intended search criteria.

Properties

NameTypeDescription

Used By

CMISQL Query

Notification