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

CMIS Query Editor

CMISQL Query - Query Editor Property Grid Editor GrooperReview.Controls.PropertyGrid

Edits a property containing a CMISQL Query, providing an interactive interface for building, testing, and executing queries against a CMIS repository.

Remarks

The CMIS Query Editor control enables users to compose, validate, and execute CMISQL Query statements for searching and retrieving documents or folders from a CMIS Repository. It is designed for advanced data integration scenarios, supporting both direct query editing and repository-assisted search.

UI Components

  • Query String Editor:
    • Allows users to enter or modify the CMISQL query string.
    • Supports syntax highlighting, code completion, and validation for CMISQL syntax.
    • Provides error feedback and guidance for query construction.
  • Repository Selection:
    • Displays the current repository context for the query.
    • Ensures that queries are executed against the correct repository, with access to its content types and properties.
  • Filter Mode Toggle:
    • Indicates whether the editor is in filter mode, affecting available query features and validation.
    • Filter mode may restrict certain query clauses or enable specialized filtering logic.
  • CMIS Repository Searcher:
    • Provides an interface for searching the repository using the current query.
    • Displays query results, supports paging, and allows users to inspect returned documents or folders.
    • Includes sub-controls for editing the query as a string, viewing results, and interacting with the property grid.

Interactive Features

  • Query Editing:
    • Edit the CMISQL query string directly, with real-time syntax validation and completion.
    • Use keyboard shortcuts for efficient editing: F8 to execute the query, Ctrl + Shift + Space for code completion.
  • Repository Search:
    • Execute the query against the selected repository and view results in a paged list.
    • Inspect returned items, including their properties and metadata.
    • Use the property grid to review and edit query parameters or returned data.
  • Error Handling:
    • Validation errors are displayed inline, with guidance for correcting syntax or repository-specific issues.
    • Repository connection errors are reported with actionable messages.

Usage Guidance

Use the CMIS Query Editor to build and test queries for importing, validating, or reporting on repository content. Enter the desired CMISQL statement, select the appropriate repository, and execute the query to view results. Leverage syntax highlighting and code completion for efficient query construction.

  • For field validation, construct queries that filter results based on Grooper field values.
  • For data import, use SELECT clauses to specify which properties to retrieve.
  • Use filter mode for specialized scenarios requiring restricted query logic.
  • Review returned results and adjust the query as needed for accuracy and performance.

Accessibility

  • Fully navigable by keyboard and mouse.
  • Screen reader support for query editor, searcher, and result list.
  • Visual cues for selection, focus, and error feedback.

Child Controls

NameTypeSummary
Notification