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

CONTAINS Predicate

Where Predicate Grooper.CMIS

Specifies full-text search criteria in a CMISQL Query.

Remarks

The CONTAINS Predicate enables full-text search within the content of documents or folders in a CMISQL Query. It allows you to specify terms and phrases that must be present in the full-text content, using a flexible search expression syntax. The general form is:

CONTAINS('<text search expression>')

The text search expression can include:

  • Terms: Single words without double quotes (e.g., computer).
  • Phrases: Exact phrases enclosed in double quotes (e.g., "computer software").
  • Wildcards: Use * to substitute for zero or more characters, and ? for exactly one character. Note that % and _ are NOT wildcards in this context.
  • Boolean Operators: Combine terms and phrases using AND, OR, and NOT. Terms separated by a space or AND are AND’ed together. AND has higher precedence than OR.
  • Negation: Prefix a term with - or use NOT to exclude it.
  • Escaping: Use a backslash (\) to escape literal single or double quote characters within a word or phrase.
  • Case Insensitivity: Full-text searches are not case-sensitive.

Elements of a Text Search Expression

Element Type Description Text Search Expression CMISQL Example
Term A single word without spaces computer CONTAINS('computer')
Phrase An exact phrase in double quotes "computer software" CONTAINS('"computer software"')
Wildcard Words/phrases with at the end "compu" CONTAINS('"compu*"')
Boolean Combine with AND, OR, NOT "computer" AND "software program" AND NOT "install component" CONTAINS('"computer" AND "software program" AND NOT "install component"')

Examples

Text Search Expression Description
grooper AND cmis
grooper cmis 		Must contain both "grooper" and "cmis".
grooper AND NOT cmis
grooper -cmis 		Must contain "grooper" and not "cmis".
grooper OR cmis Must contain either "grooper" or "cmis".
grooper AND invoice OR customer AND purchase AND order Must contain ("grooper" and "invoice") or ("customer", "purchase", "order").
"grooper cmis" Must contain the exact phrase "grooper cmis".
payroll report OR expense voucher
payroll AND report OR expense AND voucher 		Must contain ("payroll" and "report") or ("expense" and "voucher").

The CONTAINS Predicate is a powerful tool for searching document content using natural language terms, phrases, and Boolean logic. It is typically used in the WHERE clause of a CMISQL Query to filter results based on the presence or absence of specific words or phrases in the full-text content. The actual capabilities and supported syntax may vary depending on the underlying CMIS Repository and its full-text indexing features.

For more information, see the documentation for CMISQL Query, CMIS Repository, and the WHERE clause.

Properties

NameTypeDescription

Used By

CMISQL Query

Notification