Where Predicate

WHERE Predicates are CMISQL Elements that are used in the WHERE clause of a CMISQL Query.

Remarks

The Where Predicate is the abstract base for all search conditions that can be applied in the WHERE clause of a CMISQL Query. Each predicate represents a logical condition that must be satisfied for an item to be included in the query results. Predicates can be simple (such as a comparison or IN check) or complex (such as a group of conditions combined with AND/OR).

Where Predicates support logical inversion using the 'Not' property, allowing you to negate any condition or group of conditions. This enables the construction of highly flexible and expressive queries, including those with nested groups and complex Boolean logic.

Usage Guidance

• Use Where Predicate as the base for specific predicate types, such as Comparison Predicate, IN Predicate, CONTAINS Predicate, Scope Predicate, or Predicate List.
• Set the 'Not' property to invert the result of the predicate (i.e., apply a logical NOT).
• Predicates can be nested or grouped to build complex search logic.
• Each predicate is responsible for generating its own query text and for validating its configuration.

Example

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')

---

The Where Predicate is a foundational building block for Grooper's CMISQL query system, enabling precise and powerful filtering of repository content. Derived predicate types implement specific logic for different types of search conditions, but all support logical inversion and nesting through this base class.

Properties

Name	Type		Description
Not	Boolean	►	Applies a logical NOT, inverting the Boolean result of this predicate. DefaultFalse 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.

Derived Types

There are 7 implementations of Where Predicate.

AT_LEVEL Predicate	Matches objects at a specific level below the base folder.
Comparison Predicate	Specifies search criteria for an individual property in a CMISQL Query, using a comparison between the property value and a constant.
CONTAINS Predicate	Specifies full-text search criteria in a CMISQL Query.
IN Predicate	Specifies search criteria for an individual property in a CMISQL Query, using a list of allowed values.
MATCHES Predicate	Defines filtering criteria for a string property, where the property value must match a regular expression.
Predicate List	Defines a collection of search conditions to be evaluated as a group using a logical operator (AND/OR).
Scope Predicate	Restricts the search scope to the children or descendants of a folder.

Used By

CMISQL QueryPredicate List