Topics
Write an Entity Query
Define a source query that fetches entities from your data 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 data 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
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:See Also
- Configure Sources — define data sources in sheet configuration YAML
- Data Model Guides — set up entity types and relationships that queries target
- Query API Reference — technical reference for query parameters and operators
- Troubleshooting Guides — resolve query-related errors