How do data sources work in the sheet configuration?
How do data sources work in the sheet configuration?
The
sources section defines how Powersheet queries data from Polarion. Each data source specifies a model reference, a from entity type, optional where filters, expand paths for loading related entities, and take limits. Powersheet automatically applies document-scoping constraints to all queries, ensuring data is filtered to the current document context.Can I use dynamic values in my configuration?
Can I use dynamic values in my configuration?
Yes. Sheet configurations support
$context expressions that are resolved at runtime. For example, $context.document.id resolves the current document path, and $context.source.project.id resolves the source entity’s project. Dynamic values are also used in constraint definitions to route entity creation based on the source entity type.