Query Guides - Nextedy Documentation

Topics

Write an Entity Query

Define a source query that fetches entities from your domain model into the sheet. Covers from, where, and basic query structure in the sources section.

Use Predicates

Filter query results using equality, comparison, and logical operators in your source where clause to narrow down returned work items.

Expand Navigation Properties

Load related entities through expansion paths for hierarchical sheet display. Traverse domain model relationships like UserNeed to SystemRequirement.

Filter by Document

Restrict query results to work items within a specific Polarion LiveDoc. Use document constraints and the applyCurrentDocumentTo setting.

Query Baseline or Revision

Fetch historical data from specific project baselines or revisions instead of current data, enabling point-in-time traceability views.

Optimize Queries

Improve query performance for large datasets and complex expansion paths. Learn about query structure best practices and efficient predicate usage.

Queries live in the sources section

All query settings are defined inside the sources section of your sheet configuration YAML. Each source specifies a query with from (entity type), where (filter predicates), and expand (navigation properties to load). See Configure Sources for the full configuration reference.

Recommended Reading Order

If you are new to Powersheet queries, follow this sequence:

Step	Guide	What You Learn
1	Write an Entity Query	Basic query structure and the `from` / `where` pattern
2	Use Predicates	Filtering with operators and compound conditions
3	Expand Navigation Properties	Loading related entities through domain model relationships
4	Filter by Document	Scoping results to a LiveDoc context
5	Query Baseline or Revision	Accessing historical snapshots
6	Optimize Queries	Performance tuning for production sheets

​Topics