Column Type Reference

Column Type Overview

Column types define how data appears and behaves in the RISKSHEET grid. Each type has associated editors, formatters, validation rules, and storage mechanisms.

Type ID	Purpose	Editor	Data Storage	Example Binding
`string`	Plain text fields	Text input	String value	`title`, `description`
`int`	Integer numbers	Numeric input	Integer (Int64)	`priority`, `count`
`float`	Decimal numbers	Numeric input	Double precision	`weight`, `percentage`
`currency`	Money amounts	Numeric input	Decimal with precision	`cost`, `budget`
`boolean`	True/false toggle	Checkbox	Boolean	`isActive`, `approved`
`date`	Calendar date only	Date picker	Date (yyyy-MM-dd)	`dueDate`, `createdDate`
`datetime`	Date and time	DateTime picker	DateTimeOffset	`timestamp`, `modifiedTime`
`time`	Time only	Time picker	TimeOnly (hh:mm:ss)	`startTime`, `endTime`
`duration`	Time spans	Text input	String or numeric	`estimatedHours`, `actualDuration`
`enum:enumId`	Single selection from list	Dropdown/Combobox	Enum ID string	`severity:critical_major_minor`, `status`
`multiEnum:enumId`	Multiple selections from list	Multi-select editor	Colon-separated IDs	`tags:type_priority_area`
`rating:ratingId`	Numeric rating scale	Rating combobox	Integer 1-5	`rating:occurrence_5`, `likelihood`

Text and Numeric Types

String Type

{
  "header": "Description",
  "id": "description",
  "binding": "description",
  "type": "string",
  "width": 250,
  "wordWrap": true,
  "multiLine": true
}

Property	Type	Default	Description
`type`	string	`string`	Column data type identifier
`binding`	string	-	Polarion field binding path
`width`	number	auto	Column width in pixels
`minWidth`	number	-	Minimum width before truncation
`readOnly`	boolean	false	Prevents user editing
`wordWrap`	boolean	true	Enables text wrapping
`multiLine`	boolean	true	Allows multi-line editing in cells
`format`	string	-	Format string for display

Integer Type

{
  "header": "Item Count",
  "binding": "itemCount",
  "type": "int",
  "width": 80,
  "filterable": true
}

Property	Type	Default	Description
`type`	string	-	Set to `int` for integers
`dataType`	string	`Number`	Wijmo DataType
`format`	string	-	Number format (e.g., `n0`)
`width`	number	80	Typical width for numeric columns

Float and Currency Types

{
  "header": "Budget (USD)",
  "binding": "budgetAmount",
  "type": "currency",
  "width": 120,
  "format": "c2"
}

Property	Type	Default	Description
`type`	string	-	`float` for decimals, `currency` for money
`format`	string	-	`n2` for float, `c2` for currency
`precision`	number	2	Decimal places (currency only)

Currency columns use Polarion’s Currency type wrapper and maintain precise decimal handling for financial data. Float columns store unlimited decimal precision.

Date and Time Types

Date Type (Calendar Date Only)

{
  "header": "Due Date",
  "binding": "dueDate",
  "type": "date",
  "width": 100
}

Property	Type	Default	Description
`type`	string	-	Set to `date` for calendar dates
`format`	string	`yyyy-MM-dd`	ISO date format
`editor`	Control	DatePicker	Calendar input control

DateTime Type (Date + Time)

{
  "header": "Last Modified",
  "binding": "lastModifiedTime",
  "type": "datetime",
  "readOnly": true,
  "width": 160
}

Property	Type	Default	Description
`type`	string	-	Set to `datetime`
`format`	string	`yyyy-MM-dd HH:mm`	ISO format with time
`editor`	Control	DateTimePicker	Combined date/time input

Time Type (Time Only)

{
  "header": "Start Time",
  "binding": "startTime",
  "type": "time",
  "width": 80
}

Property	Type	Default	Description
`type`	string	-	Set to `time`
`format`	string	`HH:mm:ss`	24-hour time format

Duration Type

{
  "header": "Actual Effort (hours)",
  "binding": "actualEffort",
  "type": "duration",
  "width": 120
}

Property	Type	Default	Description
`type`	string	-	Set to `duration`
`storage`	string	String or Int	Stored as DurationTime or numeric value
`format`	string	-	Display format (e.g., `0.0` hours)

Duration is stored as a string type in OData despite representing time values. Use numeric parsing when integrating with external systems.

Enumeration Types

{
  "header": "Severity",
  "binding": "severity",
  "type": "enum:severity_levels",
  "width": 110,
  "showEnumDescription": true
}

Property	Type	Default	Description
`type`	string	-	Format: `enum:enumId` where enumId is the Polarion enum type
`showEnumDescription`	boolean	false	Show enum option descriptions in dropdown
`editor`	Control	EnumComboBox	Dropdown selection control
`dataMap`	EnumDataMap	-	Maps enum IDs to display names

Multi-Enum (Multi-Select)

{
  "header": "Tags",
  "binding": "tags",
  "type": "multiEnum:tag_types",
  "width": 200
}

Property	Type	Default	Description
`type`	string	-	Format: `multiEnum:enumId`
`storage`	string	Colon-separated	Values stored as `id1:id2:id3`
`editor`	Control	MultiEnumEditor	Multiple selection with checkboxes
`dataMap`	EnumDataMap	-	Maps each ID to display text

Multi-enum columns use colon (:) as a separator in the stored value, not commas. This distinguishes them from other comma-separated configurations.

Rating Type

{
  "header": "Occurrence",
  "binding": "occurrence",
  "type": "rating:occurrence_5",
  "width": 100
}

Property	Type	Default	Description
`type`	string	-	Format: `rating:ratingId`
`scale`	number	5	Number of rating options (typically 1-5)
`editor`	Control	RatingComboBox	Rating selector
`storage`	Integer	Int32	Stored as integer value

Work Item Link Types

Item Link (Single Link)

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

Property	Type	Default	Description
`type`	string	-	Set to `itemLink`
`id`	string	-	Unique column ID used in nested column bindings
`canCreate`	boolean	true	Allow creating new items from cell
`editor`	Control	AutoComplete	Suggestion-based work item selector

Multi-Item Link (Multiple Links)

{
  "header": "Related Risks",
  "binding": "relatedRisks",
  "type": "multiItemLink",
  "id": "risks",
  "width": 200
}

Property	Type	Default	Description
`type`	string	-	Set to `multiItemLink`
`id`	string	-	Column ID for referencing in nested bindings
`storage`	JSON	Array	Stored as JSON array of linked items
`editor`	Control	MultiItemLinkEditor	Add/remove multiple items

Task Link (Mitigation/Downstream Items)

{
  "header": "Mitigation",
  "binding": "task",
  "type": "taskLink",
  "id": "task",
  "width": 150
}

Property	Type	Default	Description
`type`	string	-	Set to `taskLink` for downstream items
`id`	string	-	Column ID (typically `task`, `issue`, `riskControl`)
`role`	string	defined in dataTypes	Link role (e.g., `mitigates`)
`editor`	Control	AutoComplete	Work item selector

TaskLink columns are configured through both the column definition and the dataTypes section. The column’s id must match a key in dataTypes configuration.

Workflow and Status Types

Workflow Type (Status Picker)

{
  "header": "Status",
  "binding": "status",
  "type": "workflow",
  "width": 120,
  "readOnly": false
}

Property	Type	Default	Description
`type`	string	-	Set to `workflow` for status transitions
`editor`	Control	StatusComboBox	Workflow-aware status selector
`storage`	string	Status ID	Stored as status name

Nested Column Bindings

When using link columns (itemLink, taskLink, multiItemLink), you can display properties of linked items using dot notation:

{
  "header": "Requirement Title",
  "binding": "requirement.title",
  "type": "string",
  "readOnly": true,
  "width": 200
}

Pattern	Description	Example
`linkId.fieldName`	Property of single linked item	`requirement.title`, `task.status`
`linkId.fieldName`	For multi-item links, concatenates all values	`relatedRisks.title` joins all titles
Nested properties supported	All Polarion work item fields available	`task.assignees`, `requirement.priority`

Nested columns from upstream (required) items are read-only by default. To enable editing, set readOnly: false in the column configuration, but be aware that changes affect the linked item globally.

Reference and User Types

Reference Type (User/Assignee)

{
  "header": "Assignee",
  "binding": "assignee",
  "type": "ref:users",
  "width": 120
}

Property	Type	Default	Description
`type`	string	-	Format: `ref:refId` (e.g., `ref:users`)
`editor`	Control	AutoComplete	User/reference selector
`dataMap`	ReferenceMap	-	Maps user IDs to display names

Formula and Computed Types

Formula Columns (Read-Only Calculations)

{
  "header": "RPN",
  "binding": "rpn",
  "formula": "commonRpn",
  "width": 80,
  "readOnly": true
}

Property	Type	Default	Description
`formula`	string	-	References a named formula function
`readOnly`	boolean	true	Always read-only (computed)
`storage`	variable	-	Calculated on client-side

Formula functions are defined in the configuration’s formulas object:

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

Server-Rendered Columns (Read-Only Server Computation)

{
  "header": "Computed Field",
  "binding": "computedValue",
  "serverRender": "customRenderer",
  "type": "string",
  "readOnly": true,
  "width": 150
}

Property	Type	Default	Description
`serverRender`	string	-	Server-side rendering script
`type`	string	string	Always becomes string type
`readOnly`	boolean	true	Always read-only

Type Inference and Auto-Detection

Nextedy RISKSHEET automatically detects column types from Polarion field definitions:

Polarion Field Type	Auto-Detected RISKSHEET Type
Text	`string`
TextRichFormat	`string` (HTML stripped)
Integer	`int`
Decimal	`float`
DateOnly	`date`
Date	`datetime`
TimeOnly	`time`
DurationTime	`duration`
IEnumOption / Enum	`enum:enumId`
List\	`multiEnum:enumId`
Boolean	`boolean`
User	`ref:users`
WorkItem	`itemLink`

You can override auto-detection by explicitly specifying a type in the column configuration.

OData Type Mapping

When consuming RISKSHEET data via OData APIs, column types map to EDM primitive types:

RISKSHEET Type	OData EDM Type	Example Value
`string`	String	`"Sample text"`
`int`	Int64	`42`
`float`	Double	`3.14159`
`currency`	Decimal	`1234.56`
`boolean`	Boolean	`true`
`date`	Date	`2025-12-31`
`datetime`	DateTimeOffset	`2025-12-31T14:30:00Z`
`time`	DateTimeOffset	`14:30:00`
`duration`	String	`"5.5h"` or `"330m"`
`enum`	String	`"critical"`
`multiEnum`	String	`"high:urgent"`
`rating`	Int32	`4`

Column Type Decision Matrix

Best Practices

Use specific types (date, int, currency) rather than string to enable proper sorting, filtering, and validation in the UI.

For nested bindings from linked items, use the link column’s id value to build the binding path: if your taskLink column has id: "task", reference task properties as task.title, task.status, etc.

System fields are always read-only: id, type, status, project, outlineNumber, and author. Cannot be modified through RISKSHEET.

Multi-item link columns store their values as JSON arrays. Ensure your integration code parses this correctly when syncing with external systems.

Sources

KB Articles

Support Tickets

#6179

Source Code

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

Getting Started

Concepts

Reference

Guides

Troubleshooting

FAQ

Column Type Overview

Text and Numeric Types

String Type

Integer Type

Float and Currency Types

Date and Time Types

Date Type (Calendar Date Only)

DateTime Type (Date + Time)

Time Type (Time Only)

Duration Type

Enumeration Types

Multi-Enum (Multi-Select)

Rating Type

Work Item Link Types

Item Link (Single Link)

Multi-Item Link (Multiple Links)

Task Link (Mitigation/Downstream Items)

Workflow and Status Types

Workflow Type (Status Picker)

Nested Column Bindings

Reference and User Types

Reference Type (User/Assignee)

Formula and Computed Types

Formula Columns (Read-Only Calculations)

Server-Rendered Columns (Read-Only Server Computation)

Type Inference and Auto-Detection

OData Type Mapping

Column Type Decision Matrix

Best Practices

Getting Started

Concepts

Reference

Guides

Troubleshooting

FAQ

​Column Type Overview

​Text and Numeric Types

​String Type

​Integer Type

​Float and Currency Types

​Date and Time Types

​Date Type (Calendar Date Only)

​DateTime Type (Date + Time)

​Time Type (Time Only)

​Duration Type

​Enumeration Types

​Single Enum (Dropdown)

​Multi-Enum (Multi-Select)

​Rating Type

​Work Item Link Types

​Item Link (Single Link)

​Multi-Item Link (Multiple Links)

​Task Link (Mitigation/Downstream Items)

​Workflow and Status Types

​Workflow Type (Status Picker)

​Nested Column Bindings

​Reference and User Types

​Reference Type (User/Assignee)

​Formula and Computed Types

​Formula Columns (Read-Only Calculations)

​Server-Rendered Columns (Read-Only Server Computation)

​Type Inference and Auto-Detection

​OData Type Mapping

​Column Type Decision Matrix

​Best Practices

Column Type Overview

Text and Numeric Types

String Type

Integer Type

Float and Currency Types

Date and Time Types

Date Type (Calendar Date Only)

DateTime Type (Date + Time)

Time Type (Time Only)

Duration Type

Enumeration Types

Single Enum (Dropdown)

Multi-Enum (Multi-Select)

Rating Type

Work Item Link Types

Item Link (Single Link)

Multi-Item Link (Multiple Links)

Task Link (Mitigation/Downstream Items)

Workflow and Status Types

Workflow Type (Status Picker)

Nested Column Bindings

Reference and User Types

Reference Type (User/Assignee)

Formula and Computed Types

Formula Columns (Read-Only Calculations)

Server-Rendered Columns (Read-Only Server Computation)

Type Inference and Auto-Detection

OData Type Mapping

Column Type Decision Matrix

Best Practices