Query API Reference - Nextedy Documentation

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 data 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.

Configuration vs. APIMost 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                      │
│  Translates predicates to a query   │
│  Resolves expansion paths           │
│  Applies project + document scope   │
└──────────────┬──────────────────────┘
               │
               ▼
┌─────────────────────────────────────┐
│       Polarion Data Service         │
│  Executes the query                 │
│  Returns work items + linked items  │
└─────────────────────────────────────┘

Powersheet translates your YAML sources configuration into EntityQuery objects. Predicates from the where clause are applied together with the project and document scope. Expansion paths resolve navigation properties defined in your data model to load related entities in a single request.

Topic	Where to look
Configuring data sources in YAML	Sources
Data model entity types and relationships	Data Model Reference
Column binding paths that drive queries	Binding Syntax
Server-rendered computed properties	Server Rendering Reference

EntityQuery

Predicates

Expand Clause

Query Context

Document Filtering

Baseline and Revision Queries

​How Queries Flow

​Related References

How Queries Flow

Related References