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

Select Element

CMISQL Element Grooper.CMIS

Represents an element of a SELECT clause in a CMISQL Query.

Remarks

The Select Element defines a single property or wildcard to be included in the result set of a CMISQL Query. Each Select Element corresponds to a column in the query results and determines which property values are returned for each matching item.

You can specify a property by its query name, use a type wildcard (e.g., TypeName.) to select all properties of a type, or use the global wildcard () to select all available properties. Optionally, you may assign an alias to the selected property for use in the result set.

Usage Guidance

  • Set the 'Property Name' to the query name of the property you want to include, or use * for all properties.
  • Use a type wildcard (e.g., Document.*) to select all properties from a specific type.
  • Optionally, set the 'Alias Name' to rename the column in the result set.
  • Each Select Element is validated to ensure the property or type exists in the repository.

Examples

Select a single property: SELECT cmis:name FROM File

Select all properties of a type: SELECT File.* FROM File

Select all properties (global wildcard): SELECT * FROM File

Select a property with an alias: SELECT cmis:name AS 'DocumentName' FROM File

The Select Element is a core building block for defining which data is returned by a CMISQL Query. Proper configuration ensures that the query returns the desired columns, with appropriate names, and that all referenced properties are valid in the context of the selected content type.

Properties

NameTypeDescription

Used By

CMISQL Query

Notification