Column Type Reference - Nextedy Documentation

Column Definition Properties

Every column in the columns array accepts the following properties:

Property	Type	Default	Description
`id`	`string`	Auto-generated from `header` or `binding`	Unique identifier for the column. Referenced by formulas, cell decorators, views, and `sortBy`.
`binding`	`string`	Same as `id`	The Polarion work item field name this column reads from and writes to.
`header`	`string`	None	Display text shown in the column header row.
`type`	`string`	Auto-detected from Polarion field	Data type identifier that controls editor, display, sorting, and data conversion. See Supported Type Identifiers.
`width`	`number`	See application	Column width in pixels.
`minWidth`	`number`	See application	Minimum width in pixels the column can be resized to.
`level`	`number`	`1`	Hierarchical level at which this column appears. `1` = top level (failure mode), `2` = second level (cause/effect), etc. Not set for task columns.
`readOnly`	`boolean`	`false`	Controls whether cells are editable. Automatically set to `true` for formula columns, server-rendered columns, reference columns, and system fields (`author`, `resolution`, `created`, `updated`, `type`).
`filterable`	`boolean`	`true`	Controls whether users can filter the grid by values in this column.
`canCreate`	`boolean`	`true`	For `itemLink` and `multiItemLink` columns only. Controls whether users can create new linked items directly from the cell.
`formula`	`string`	None	References a named formula from the `formulas` section. When set, the column becomes read-only automatically. See Calculated Columns.
`serverRender`	`string`	None	Server-side Velocity rendering script. When set, column becomes `text` type and read-only automatically. See Server Render Columns.
`headerGroup`	`string`	None	Name of the header group this column belongs to. Columns with the same `headerGroup` value are displayed under a shared group header.
`headerGroupCss`	`string`	None	CSS class name(s) applied to the header group row for this column’s group.
`collapseTo`	`string`	None	The column `id` to collapse this column into when the header group is collapsed.
`cellRenderer`	`string`	None	Name of a custom cell renderer function for this column. See Custom Renderer Templates.
`cellCss`	`string`	None	CSS class name(s) applied to every cell in this column.
`format`	`string`	None	Display format string for the column data (e.g., date format, number format).
`multiLine`	`boolean`	`true`	Enables multi-line text display and editing within cells.
`wordWrap`	`boolean`	`true`	Controls whether text wraps within cells.
`isContentHtml`	`boolean`	See application	When `true`, cell content is rendered as HTML rather than plain text.

The readOnly property is automatically set to true regardless of your configuration when any of these conditions apply: the column has a formula, the column has a serverRender script, the column references a cross-project item, the bound field is a protected system field (id, status, type, project, outlineNumber), or the user lacks write permission to the field.

Supported Type Identifiers

The type property accepts the following identifiers. Types that use the colon syntax (e.g., enum:id) carry additional configuration after the type prefix.

Type	Description	Editor	OData Type	Details
`text`	Plain text / rich text (stripped)	Text input	`Edm.String`	Rich text converted to plain text. Default for unrecognized types.
`string`	Alias for `text`	Text input	`Edm.String`	Same behavior as `text`.
`int`	Integer number	Numeric input	`Edm.Int64`	64-bit signed integer.
`float`	Floating-point number	Numeric input	`Edm.Double`	Double precision.
`boolean`	True/false value	Checkbox	`Edm.Boolean`	Accepts string `"true"` / `"false"`.
`date`	Date only	Date picker	`Edm.Date`	Format: `yyyy-MM-dd`.
`datetime`	Date and time	DateTime picker	`Edm.DateTimeOffset`	Full timestamp with timezone.
`time`	Time only	Time picker	`Edm.DateTimeOffset`	Format: `hh:mm:ss`.
`currency`	Decimal currency	Numeric input	`Edm.Decimal`	BigDecimal precision.
`rating`	Rating scale value	Dropdown	`Edm.Int32`	Colon syntax: `rating:scaleId`.
`duration`	Time span	Text input	`Edm.String`	Polarion DurationTime format.
`enum`	Single enum selection	Dropdown	`Edm.String`	Colon syntax: `enum:enumId`.
`multiEnum`	Multi-enum selection	Multi-select	`Edm.String`	Colon syntax: `multiEnum:enumId`.
`workflow`	Workflow status	Status display	`Edm.String`	Displays workflow state.
`itemLink`	Single linked item	Link picker	`Edm.String`	Upstream traceability.
`multiItemLink`	Multiple linked items	Multi-link picker	`Edm.String`	Multiple upstream links.
`taskLink`	Downstream task link	Link picker	`Edm.String`	Downstream mitigation tasks.
`ref`	Reference / user field	Reference picker	`Edm.String`	Colon syntax: `ref:refId`.

When you omit the type property, Risksheet infers the type from the bound Polarion field. For example, a field defined as an integer in Polarion automatically becomes an int column, and a native enum field becomes an enum column. Explicitly setting type overrides this inference.

Colon Syntax for Parameterized Types

Several column types support a colon-separated syntax: baseType:parameter. The parameter portion references a named definition in the enums, ratings, or refs sections of risksheet.json.

Syntax Pattern	Base Type	Parameter	Configuration Section
`enum:severity`	`enum`	`severity`	`enums.severity`
`rating:occurrence`	`rating`	`occurrence`	`ratings.occurrence`
`multiEnum:affectedSystems`	`multiEnum`	`affectedSystems`	`enums.affectedSystems`
`ref:requirement`	`ref`	`requirement`	`refs.requirement`
`multiEnum:@NoIDWorkItems[type]`	`multiEnum`	`@NoIDWorkItems[type]`	WorkItem enum from XML

The type parser extracts the prefix before the first colon to determine the base data type, then passes the remainder as configuration context.

Column Sorting Behavior

Risksheet applies specialized sorting logic based on column type and binding. Sorting is performed client-side for immediate feedback without server round-trips.

Column Type / Binding	Sorting Behavior
`id` binding	Custom alphanumeric sort (e.g., `PROJECT-2` before `PROJECT-10`)
`outlineNumber` binding	Hierarchical sort (e.g., `1.2` before `1.10`)
`itemLink`, `taskLink`	Sorted by linked item’s display property
`multiItemLink`	Sorted by concatenated labels of all linked items
Nested columns (linked item properties)	Sorted by the linked item’s property value
Default (all other types)	Standard ascending/descending sort

Configuring initial sort order uses the sortBy property:

{
  "sortBy": ["~rpn", "sev"]
}

This sorts by RPN descending (tilde prefix ~ indicates descending), then by severity ascending.

When comparing to a baseline revision, sorting operates on the baseline snapshot values rather than current values, except for systemItemId and systemItemRevision which always reference the current item.

Known Limitations

Limitation	Details
First ID column cannot be renamed	The first `Item Id` column in the grid cannot have its header renamed. This is a known platform limitation.
Single-user assignment only	User reference (`ref`) columns support single-user assignment. Multi-user assignment requires the Polarion native form.
Unsaved item sort prefix	Newly created items not yet saved display with an asterisk (`*`) prefix in their ID, which affects sort order.

Column Configuration Examples

Basic Text Column

{
  "id": "failureMode",
  "binding": "title",
  "header": "Failure Mode",
  "type": "text",
  "width": 250,
  "level": 1
}

Rating Column with Scale

{
  "id": "sev",
  "binding": "sev",
  "header": "Severity (S)",
  "type": "rating:severity",
  "width": 80,
  "level": 2
}

Calculated RPN Column

{
  "id": "rpn",
  "binding": "rpn",
  "header": "RPN",
  "type": "int",
  "width": 70,
  "formula": "commonRpn",
  "level": 2
}

The formula commonRpn is defined in the formulas section:

{
  "formulas": {
    "commonRpn": "function(info){ var value = info.item['occ']*info.item['det']*info.item['sev']; return value?value:null;}"
  }
}

Grouped Columns with Header

[
  {
    "id": "sev",
    "binding": "sev",
    "header": "Severity (S)",
    "type": "rating:severity",
    "headerGroup": "Initial Risk Assessment",
    "width": 80,
    "level": 2
  },
  {
    "id": "occ",
    "binding": "occ",
    "header": "Occurrence (O)",
    "type": "rating:occurrence",
    "headerGroup": "Initial Risk Assessment",
    "width": 80,
    "level": 2
  },
  {
    "id": "det",
    "binding": "det",
    "header": "Detection (D)",
    "type": "rating:detection",
    "headerGroup": "Initial Risk Assessment",
    "width": 80,
    "level": 2
  },
  {
    "id": "rpn",
    "binding": "rpn",
    "header": "RPN",
    "type": "int",
    "headerGroup": "Initial Risk Assessment",
    "width": 70,
    "formula": "commonRpn",
    "level": 2
  }
]

Upstream Traceability Column

{
  "id": "requirement",
  "binding": "requirement",
  "header": "Linked Requirement",
  "type": "itemLink",
  "width": 200,
  "canCreate": false,
  "level": 1
}

Server-Rendered Column

{
  "id": "testStatus",
  "binding": "testStatus",
  "header": "Test Status",
  "serverRender": "testStatusRenderer",
  "width": 150,
  "level": 2
}

When serverRender is set, the column type is automatically forced to text and readOnly to true.

Complete Example

A full columns array for an automotive FMEA risksheet with initial assessment, mitigation actions, and revised assessment:

{
  "columns": [
    {
      "id": "failureMode",
      "binding": "title",
      "header": "Failure Mode",
      "type": "text",
      "width": 220,
      "level": 1
    },
    {
      "id": "effect",
      "binding": "effect",
      "header": "Effect of Failure",
      "type": "text",
      "width": 200,
      "level": 2
    },
    {
      "id": "cause",
      "binding": "cause",
      "header": "Potential Cause",
      "type": "text",
      "width": 200,
      "level": 2
    },
    {
      "id": "sev",
      "binding": "sev",
      "header": "S",
      "type": "rating:severity",
      "headerGroup": "Initial",
      "width": 60,
      "level": 2
    },
    {
      "id": "occ",
      "binding": "occ",
      "header": "O",
      "type": "rating:occurrence",
      "headerGroup": "Initial",
      "width": 60,
      "level": 2
    },
    {
      "id": "det",
      "binding": "det",
      "header": "D",
      "type": "rating:detection",
      "headerGroup": "Initial",
      "width": 60,
      "level": 2
    },
    {
      "id": "rpn",
      "binding": "rpn",
      "header": "RPN",
      "type": "int",
      "headerGroup": "Initial",
      "formula": "commonRpn",
      "width": 65,
      "level": 2
    },
    {
      "id": "mitigationAction",
      "binding": "mitigationAction",
      "header": "Recommended Action",
      "type": "text",
      "width": 200,
      "level": 2
    },
    {
      "id": "dueDate",
      "binding": "dueDate",
      "header": "Due Date",
      "type": "date",
      "width": 110,
      "level": 2
    },
    {
      "id": "sevNew",
      "binding": "sevNew",
      "header": "S",
      "type": "rating:severity",
      "headerGroup": "Revised",
      "width": 60,
      "level": 2
    },
    {
      "id": "occNew",
      "binding": "occNew",
      "header": "O",
      "type": "rating:occurrence",
      "headerGroup": "Revised",
      "width": 60,
      "level": 2
    },
    {
      "id": "detNew",
      "binding": "detNew",
      "header": "D",
      "type": "rating:detection",
      "headerGroup": "Revised",
      "width": 60,
      "level": 2
    },
    {
      "id": "rpnNew",
      "binding": "rpnNew",
      "header": "RPN",
      "type": "int",
      "headerGroup": "Revised",
      "formula": "commonRpnNew",
      "width": 65,
      "level": 2
    }
  ],
  "formulas": {
    "commonRpn": "function(info){ var value = info.item['occ']*info.item['det']*info.item['sev']; return value?value:null;}",
    "commonRpnNew": "function(info){ var value = info.item['occNew']*info.item['detNew']*info.item['sevNew']; return value?value:null;}"
  }
}

Data Types — detailed type behavior, OData mapping, and storage
Enum Columns — enum and rating enumeration configuration
Multi-Enum Columns — multi-select dropdown setup
Item Link Columns — upstream traceability columns
Task Link Columns — downstream task link columns
Calculated Columns — formula-based columns
Server Render Columns — server-side rendered columns
Conditional Formatting — cell decorators and styles
Risksheet.json Format — full configuration format
Configuration Properties Index — all property reference

Sources

KB Articles

Support Tickets

#6677

Source Code

risksheet.json
PolarionAppConfigManager.java
SheetConstants.ts
ColumnTypeManager.java
AppConfig.ts

​Column Definition Properties

​Supported Type Identifiers

​Colon Syntax for Parameterized Types

​Column Sorting Behavior

​Known Limitations

​Column Configuration Examples

​Basic Text Column

​Rating Column with Scale

​Calculated RPN Column

​Grouped Columns with Header

​Upstream Traceability Column

​Server-Rendered Column

​Complete Example

​Related Pages

Column Definition Properties

Supported Type Identifiers

Colon Syntax for Parameterized Types

Column Sorting Behavior

Known Limitations

Column Configuration Examples

Basic Text Column

Rating Column with Scale

Calculated RPN Column

Grouped Columns with Header

Upstream Traceability Column

Server-Rendered Column

Complete Example

Related Pages