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

AT_LEVEL Predicate

Where Predicate Grooper.CMIS

Matches objects at a specific level below the base folder.

Remarks

The AT_LEVEL Predicate is used in import filters to restrict results to items located at a specific depth beneath the base folder in a CMIS Repository.

This predicate is only valid in the context of import operations (see Import Descendants) and is not supported in standard CMISQL Query statements.

The AT_LEVEL Predicate takes the form: AT_LEVEL(Level)

  • Level is an integer from 1 to 64, representing the number of levels below the base folder.
    • AT_LEVEL(1) targets immediate children of the base folder.
    • AT_LEVEL(2) targets grandchildren (i.e., items two levels below the base folder).
    • Higher values target deeper descendants.

Usage Guidance

  • Use the AT_LEVEL Predicate to precisely control which items are included during import, based on their depth in the folder hierarchy.
  • If no AT_LEVEL Predicate is present when importing documents, all levels below the base folder will be included.
  • When importing folders, an implicit AT_LEVEL(1) is assumed if none is specified, so only immediate children are included by default.
  • The allowed range for Level is 1 to 64. Values outside this range will result in a validation error.

Example

To import only the immediate children of a folder: AT_LEVEL(1)

To import only grandchildren (two levels below the base folder): AT_LEVEL(2)

The AT_LEVEL Predicate is a powerful tool for fine-tuning import operations, ensuring that only items at the desired depth are included. This is especially useful in scenarios where the folder structure is deep or complex, and you want to avoid importing unwanted descendants.

Properties

NameTypeDescription

Used By

CMISQL Query

Notification