Skip to main content

​
Prerequisites

  • A Polarion project with at least one baseline created
  • A working powersheet document with configured data sources
  • Understanding of Polarion baselines (project-level snapshots)

​
Step 1: Open a Document in Revision Mode via the UI

The simplest way to view historical data is through the Powersheet History menu:
  1. Open the powersheet document in Polarion
  2. Navigate to the History menu group in the toolbar
  3. Select the desired baseline or revision number
  4. The document reloads with historical data
When viewing a document in revision mode, the sheet is automatically set to read-only. You cannot edit work items while viewing historical data.

​
Step 2: Open a Revision via URL Parameter

You can link directly to a specific revision by appending the revision parameter to the Powersheet URL: 
/polarion/#/project/myProject/powersheet?document=Folder/DocName&revision=42
ParameterValueDescription
revisionInteger >= 0Specific revision number to view
(omitted)—Shows latest (HEAD) data
diagram
The revision URL parameter enables bookmarking and sharing specific historical snapshots. Share the full URL with team members for audit reviews or milestone comparisons.

​
Step 3: Return to Current Data

To exit revision mode and return to the live document:
  1. Open the History menu
  2. Select Close Revision (or the equivalent option to return to HEAD)
  3. The document reloads with current data and editing is re-enabled
Alternatively, remove the revision parameter from the URL and reload.

​
Step 4: Create a Baseline in Polarion

Baselines are created in Polarion, not in Powersheet. Each baseline captures a project-wide snapshot that Powersheet can reference by revision number:
  1. In Polarion, navigate to your project
  2. Go to Administration > Baselines (or the equivalent baseline management page)
  3. Create a new baseline
  4. Note the revision number assigned to the baseline
The exact steps for creating baselines may vary depending on your Polarion version and project configuration. Consult your Polarion administrator for project-specific baseline procedures.

​
How Revision Queries Work

When you open a document with a revision parameter, the query engine executes all queries against the historical data snapshot rather than the current state. The revision can come from:
  • The revision URL query parameter (explicit user request)
  • A context baseline set by the Polarion project
All entity queries, navigation property expansions, and constraint evaluations operate on the historical snapshot. Enum options and picker values also reflect the state at that revision.
The revision parameter must be a non-negative integer. Invalid values may cause the document to fail to load. If you encounter issues, verify the baseline exists in your Polarion project.

​
Step 5: Inspect Revision in Document Title

When viewing a historical revision, the document title updates to include the revision number in parentheses. For example:
  • Current: “RTM Requirements Traceability”
  • Revision 42: “RTM Requirements Traceability (Revision 42)”
This visual indicator confirms you are viewing historical data.

​
Verify

After opening a document with a revision parameter:
  1. You should now see the document title with the revision number appended
  2. The sheet should display data as it existed at that point in time
  3. All editing controls should be disabled (read-only mode)
  4. Closing the revision should return you to the current live data with editing re-enabled

​
See Also

Source Code
  • PolarionQueryProcessor.java
  • prod-powersheet-src/com.nextedy.powersheet.client/src/modules/DocumentProvider/DocumentProvider.tsx
  • powersheet.yaml
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/e2e/userFlows/revision.cy.ts
  • GenericQueryResolver.java