Getting Started with Queries
Write an Entity Query — Define a source query that fetches entities from your domain model into the sheet Use Predicates — Filter query results using equality, comparison, and logical operators in your sourcewhere clause
Expanding Relationships
Expand Navigation Properties — Load related entities through expansion paths for hierarchical sheet displayScoping and Filtering
Filter by Document — Restrict query results to work items within a specific Polarion document Filter by Project — Scope queries to a single project or multiple projectsAdvanced Query Features
Use Function Expressions — Apply functions and computed expressions within query definitions Query Baseline or Revision — Fetch historical data from specific project baselines or revisions Optimize Queries — Improve query performance for large datasets and complex expansion pathsQueries are defined in the sources section
Queries are defined in the sources section
All query settings live inside the
sources section of your sheet configuration YAML. Each source defines a query with from, where, and expansion settings. See Configure Sources for the configuration reference.See Also
- Configure Sources — define data sources in sheet configuration YAML
- Data Model Guides — set up entity types and relationships that queries target
- Troubleshooting Guides — resolve query-related errors
Sources
Sources
Source Code
GenericQueryResolver.javaprod-powersheet-src/com.nextedy.powersheet.client/src/modules/ModelProvider/ModelProvider.tsxOperator.javaprod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/configurations/whole_rtm.template.yamlpowersheet.yaml