Skip to main content

​
Query Building Blocks

EntityQuery — Top-level query object that combines a from clause, predicates, expand, order-by, and select into a single data request. Predicates — Filter conditions applied in the where clause. Support equality, comparison, null checks, and composite AND/OR logic. Operators — Comparison and logical operators used within predicates: eq, ne, gt, lt, contains, and, or, not, and collection quantifiers any/all. Expand Clause — Defines which related entities to load inline via expansion paths, reducing round-trips for hierarchical data. Order By Clause — Specifies sort order for query results using property paths with ascending or descending direction. Select Clause — Projects specific properties to return in query results, controlling payload size. Function Expressions — Built-in string, date, and math functions for transforming property values within query expressions. Query Context — Runtime context parameters including document scoping, project constraints, baseline/revision, and dynamic value resolution.

​
Query Execution

Lucene Integration — How Powersheet predicates translate to Polarion Lucene queries for server-side execution. Query Splitting — Optimization strategy that splits predicates into Lucene-compatible server queries and in-memory post-filters. Document Filtering — Scoping queries to the current Polarion document using applyCurrentDocumentTo constraints. Project Scoping — Restricting query results to specific Polarion projects via project.id filters. Baseline and Revision Queries — Querying historical data at specific project baselines or revisions.
Most query behavior is configured declaratively through the sources section of your sheet configuration YAML. The pages in this section document the underlying query model that the configuration drives. See Sources for the YAML configuration reference.
diagram
Source Code
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/cypress/e2e/Sheet/reference.spec.ts
  • GenericQueryResolver.java
  • powersheet.yaml
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/configurations/constraints_currentDocument_downstream.template.yaml
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/configurations/whole_rtm.template.yaml