Skip to main content
diagram

​
Column Type

SyntaxDescription
itemLinkAuto-detected when binding refers to a linked work item field
itemLink displays only one linked item per cell. If multiple items are linked, additional links are silently dropped. Use Multi-Item Link Columns when you need to display multiple linked items in a single cell.

​
Column Properties

NameTypeDefaultDescription
idstringAuto-generated from header or bindingUnique identifier for the column
typestringAuto-detected from bindingSet to itemLink for single-item link columns
headerstringNoneDisplay text in the column header
bindingstringSame as idThe Polarion field ID or link property. Must contain a dot (e.g., sysReq.title)
readOnlybooleanfalseControls whether the column cells can be edited
canCreatebooleantrueControls whether users can create new linked items from the cell
filterablebooleantrueControls whether users can filter by values in this column
levelnumber1Hierarchical level at which this column appears
widthnumberSee applicationColumn width in pixels
minWidthnumberSee applicationMinimum resize width in pixels
headerGroupstringNoneHeader group for multi-level headers
isContentHtmlbooleanSee applicationIndicates cell content is rendered as HTML

​
Binding Convention

Item link columns use a dot notation binding pattern:
PatternDescription
linkName.propertyBinds to a property of the linked item (e.g., sysReq.title)
linkName_linkSuffix _link provides the HTML hyperlink URL for the linked item
Item link bindings must contain a dot character. The system logs a warning for invalid configurations: "Invalid column config, itemLink bindings without dot.".

​
Autocomplete Behavior

When editing an item link cell, an autocomplete editor searches for linkable items via OData queries. The search requires a minimum of 3 characters before returning results.
BehaviorDescription
SearchSubstring match on item ID and type, minimum 3 characters
queryFactoryOptional custom query constraints via window.risksheet.queryFactories
Dependent columnsSelecting an item automatically populates nested columns from the selected item’s properties
Duplicate preventionError displayed if item is already linked: "This item is already linked to selected row."

​
Disabling Item Creation

Set canCreate to false to allow linking and unlinking existing items while preventing creation of new items. 
{
  "columns": [
    {
      "id": "sysReq",
      "header": "System Requirement",
      "type": "itemLink",
      "binding": "sysReq.title",
      "canCreate": false
    }
  ]
}
Use "canCreate": false for upstream columns where linked items should be pre-created in the tracker rather than created inline.

​
Multi-Project Support

Item link columns can load items from multiple projects. When creating new items in a multi-project column, the system saves to the first mentioned project by default.
PropertyDescription
createInCurrentDocumentSet to true in typeProperties to save new items in the current project
project and documentSpecify target project and document for new item storage
The checkLinkRoleCompliance property (version 24.2.2+) enables multiple link roles from Risk for item link columns.
The checkLinkRoleCompliance property must be explicitly enabled in Polarion Administration Configuration Properties via nextedy.risksheet.checkLinkRoleCompliance=true. This is a backward incompatible change.

​
Context Menu

Right-click on an item link cell to access:
ActionDescription
Open Linked ItemOpens the linked work item in Polarion’s item editor. Available when cell contains a valid item link.

​
Cell Merging

Item link columns participate in hierarchical cell merging. When undoing edits to merged item link cells, the undo operation applies to all rows in the merged range.

​
Export Behavior

FormatRendering
ExcelPlain text with HTML formatting stripped
PDFLabel property displayed as text

​
Complete Example

{
  "columns": [
    {
      "id": "sysReq",
      "header": "System Requirement",
      "type": "itemLink",
      "binding": "sysReq.title",
      "level": 1,
      "width": 200,
      "canCreate": false,
      "filterable": true,
      "typeProperties": {
        "linkTypes": ["systemRequirement"],
        "createInCurrentDocument": true
      }
    }
  ],
  "dataTypes": {
    "risk": {
      "type": "fmeaRisk",
      "role": "mitigates"
    }
  }
}
KB ArticlesSupport TicketsSource Code
  • SheetConstants.ts
  • RiskSheetContextMenu.ts
  • PolarionAppConfigManager.java
  • ExportToExcel.ts
  • risksheet.json