Skip to main content

EntityQuery

Top-level query object that combines a resource type, predicates, expand clauses, and ordering into a single data request against the server API.

Predicates

Filter conditions for the where clause including equality, comparison, null checks, and composite AND/OR logic with support for property paths.

Expand Clause

Load related entities inline via expansion paths, supporting one-to-many, many-to-one, and many-to-many relationships through navigation properties.

Query Context

Document Filtering

Scope query results to items within a specific Polarion LiveDoc using applyCurrentDocumentTo constraints in the domain model.

Baseline and Revision Queries

Query historical data at specific project baselines or revisions to view the state of entities at a point in time.
Most query behavior is configured declaratively through the sources section of your sheet configuration YAML. You rarely need to write queries directly — Powersheet translates your YAML sources into the query structures described here. See Sources for the configuration reference.

​
How Queries Flow

┌─────────────────────────────────────┐
│        Sheet Configuration          │
│  sources:                           │
│    - type: UserNeed                 │
│      expand:                        │
│        - systemRequirements         │
│      where:                         │
│        status: { ne: deleted }      │
└──────────────┬──────────────────────┘
               │
               ▼
┌─────────────────────────────────────┐
│          EntityQuery                │
│  from: UserNeed                     │
│  where: Predicates                  │
│  expand: Expand Clause              │
│  context: Query Context             │
└──────────────┬──────────────────────┘
               │
               ▼
┌─────────────────────────────────────┐
│     Server API (Lucene)             │
│  Translates predicates to Lucene    │
│  Resolves expansion paths           │
│  Applies project + document scope   │
└──────────────┬──────────────────────┘
               │
               ▼
┌─────────────────────────────────────┐
│       Polarion Data Service         │
│  Executes Lucene search             │
│  Returns work items + linked items  │
└─────────────────────────────────────┘
The query engine translates your YAML sources configuration into EntityQuery objects. Predicates from the where clause are split into Lucene-compatible server queries and in-memory post-filters where needed. Expansion paths resolve navigation properties defined in your domain model to load related entities in a single request.
TopicWhere to look
Configuring data sources in YAMLSources
Domain model entity types and relationshipsData Model Reference
Column binding paths that drive queriesBinding Syntax
Server-rendered computed propertiesServer Rendering Reference