Supported Field Types - Nextedy Documentation

Polarion-to-Risksheet Field Type Matrix

Polarion Field Type	Risksheet Column Type	Editor	Display	Notes
`String`	`text`	Text input	Plain text	Default mapping for string fields
`Text` (Rich Text)	`text`	Text input	Plain text (stripped)	Rich text formatting removed; links processed
`Integer`	`int`	Numeric input	Whole number	Also usable as `rating` for risk scales
`Float`	`float`	Numeric input	Decimal number	Double precision
`Boolean`	`boolean`	Checkbox	Checked/unchecked	Accepts string `"true"` / `"false"`
`Date`	`date`	Date picker	`yyyy-MM-dd`	Date-only value
`Date`	`datetime`	DateTime picker	Full timestamp	Date with time component
`Date`	`time`	Time picker	`hh:mm:ss`	Time-only value
`Enum` (single)	`enum:id`	Dropdown	Enum option ID	Status field shows name instead of ID
`List<IEnumOption>`	`multiEnum:id`	Multi-select	Multiple enum IDs	Blank options auto-filtered
`Currency`	`currency`	Numeric input	Decimal value	BigDecimal precision preserved
`DurationTime`	`duration`	Text input	Duration string	Parsed via Polarion DurationTime format
`User` (assignee)	`ref`	User picker	User ID	Single-user assignment only

Text and String Fields

Risksheet handles both plain String fields and rich Text fields from Polarion. Both map to the text column type.

Behavior	String Field	Text (Rich Text) Field
Display	As-is	Stripped to plain text
Link processing	None	Links auto-processed for rendering
Editing	Direct text input	Direct text input (plain text only)
Multi-line	Enabled (`multiLine: true`)	Enabled (`multiLine: true`)
Word wrap	Enabled (`wordWrap: true`)	Enabled (`wordWrap: true`)

{
  "id": "description",
  "binding": "description",
  "header": "Description",
  "type": "text",
  "width": 300
}

When editing a rich text field through Risksheet, formatting is not preserved. The field is saved as plain text. To preserve rich text formatting, edit the field through the standard Polarion work item form.

Numeric Fields

Risksheet supports four numeric column types with different precision and semantics:

Column Type	Polarion Storage	Precision	OData Type	Typical Use
`int`	Integer	64-bit signed	`Edm.Int64`	Priority, count, sequence
`rating`	Integer	32-bit signed	`Edm.Int32`	Risk scales (S/O/D)
`float`	Float	Double precision	`Edm.Double`	Risk scores, percentages
`currency`	Currency	BigDecimal	`Edm.Decimal`	Cost, financial values

The int and rating types are interchangeable at the storage level. rating is semantically intended for risk assessment parameters and maps to a 32-bit integer in OData, while int maps to 64-bit.

{
  "columns": [
    {
      "id": "sev",
      "binding": "sev",
      "header": "Severity",
      "type": "rating:severity",
      "width": 80
    },
    {
      "id": "priority",
      "binding": "priority",
      "header": "Priority",
      "type": "int",
      "width": 80
    },
    {
      "id": "riskScore",
      "binding": "riskScore",
      "header": "Score",
      "type": "float",
      "width": 100
    },
    {
      "id": "cost",
      "binding": "mitigationCost",
      "header": "Cost ($)",
      "type": "currency",
      "width": 100
    }
  ]
}

Type Conversion Between Numeric Types

Risksheet can convert between numeric types and string representations:

Source Value	Target Type	Result
String `"42"`	`int`	Integer `42`
String `"3.14"`	`float`	Float `3.14`
Integer `5`	`rating`	Rating value `5`
Float `99.95`	`currency`	BigDecimal `99.95`
Integer `3`	`enum`	Enum option with ID `"3"`

Boolean Fields

Boolean columns render as checkboxes in the grid. The conversion system handles both native Boolean objects and string representations.

Input Value	Stored As	Display
`true`	Boolean `true`	Checked checkbox
`false`	Boolean `false`	Unchecked checkbox
`"true"` (string)	Boolean `true`	Checked checkbox
`"false"` (string)	Boolean `false`	Unchecked checkbox
`null`	No value	Unchecked checkbox

{
  "id": "mitigated",
  "binding": "mitigated",
  "header": "Mitigated",
  "type": "boolean",
  "width": 80
}

Date and Time Fields

Risksheet supports three temporal column types, all backed by Polarion’s Date field type. The column type setting determines which component is displayed.

Column Type	Displays	Format	Backing Polarion Type
`date`	Date only	`yyyy-MM-dd`	Date, Calendar, ISO string
`datetime`	Date and time	Full timestamp	Date, Calendar, ISO string
`time`	Time only	`hh:mm:ss`	Date, Calendar, ISO string

The conversion system automatically handles:

Polarion Date objects
Java Date and Calendar objects
ISO 8601 format strings (yyyy-MM-dd for dates, hh:mm:ss for times)

{
  "columns": [
    {
      "id": "dueDate",
      "binding": "dueDate",
      "header": "Due Date",
      "type": "date",
      "width": 120
    },
    {
      "id": "lastModified",
      "binding": "updated",
      "header": "Last Modified",
      "type": "datetime",
      "width": 160,
      "readOnly": true
    }
  ]
}

Date and time display formats are affected by the global.culture setting. For example, en uses MM/DD/YYYY display, while de uses DD.MM.YYYY. See Culture and Localization Codes.

Enumeration Fields

Risksheet supports both single-select and multi-select enumerations.

Single Enum

Behavior	Details
Display	Enum option ID (exception: `status` field shows name)
Editor	Dropdown selector
Backing fields	Native Polarion enum, String, Integer
Configuration	`enum:enumerationId` references `enums` section in `risksheet.json`

{
  "id": "riskCategory",
  "binding": "riskCategory",
  "header": "Risk Category",
  "type": "enum:riskCategory",
  "width": 140
}

Multi-Select Enum

Behavior	Details
Display	Multiple selected values
Editor	Multi-select checkbox dropdown
Backing fields	Polarion `List<IEnumOption>`, comma-separated String
Blank handling	Blank options automatically filtered out
Configuration	`multiEnum:enumerationId` references `enums` section

{
  "id": "affectedSystems",
  "binding": "affectedSystems",
  "header": "Affected Systems",
  "type": "multiEnum:affectedSystems",
  "width": 200
}

WorkItem enum fields (enumerations of work item types) require specific type syntax matching the XML custom field definition. For example: "type": "multiEnum:@NoIDWorkItems[workpackage]". These have limited support compared to standard enum fields.

See Enum Columns and Multi-Enum Columns for detailed configuration.

Duration Fields

Duration columns handle Polarion DurationTime fields and can also store durations in Integer or Float fields.

Property	Details
Display	Duration string (e.g., `"1d 4h"`, `"2h 30m"`)
Parsing	Uses Polarion’s `DurationTime.fromString()`
Backing fields	DurationTime, Integer, Float
OData type	`Edm.String` (string-encoded)

{
  "id": "effortEstimate",
  "binding": "effortEstimate",
  "header": "Effort Estimate",
  "type": "duration",
  "width": 120
}

User Reference Fields

User reference columns handle Polarion user assignment (assignee) fields with special behavior:

Mode	Behavior
Read-only	Displays user ID as string
Editable	Clears all existing assignees, adds specified user
Assignment	Single-user assignment only

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

Editable user columns support single-user assignment only. Setting a new user clears all existing assignees. For multi-user assignment, use the standard Polarion work item form.

Read-Only System Fields

The following Polarion fields are always read-only in Risksheet. Save attempts are silently ignored:

Field	Description	Read-Only Reason
`id`	Work item ID	Identity field, immutable
`status`	Workflow status	Controlled by workflow transitions
`type`	Work item type	Immutable after creation
`project`	Project assignment	Immutable
`outlineNumber`	Document outline number	Managed by Polarion
`author`	Item creator	Set at creation time
`resolution`	Resolution value	Managed by workflow
`created`	Creation timestamp	Set at creation time
`updated`	Last modification	Auto-updated by Polarion

Type Override

You can override the auto-detected type by explicitly setting the type property on a column. This allows displaying a Polarion field differently from its native storage type.

Polarion Field	Native Type	Override	Result
String	`text`	`type: "date"`	Parses string as date
Integer	`int`	`type: "enum:scale"`	Displays as enum dropdown
String	`text`	`type: "boolean"`	Parses `"true"` / `"false"`
Float	`float`	`type: "int"`	Truncates to integer

{
  "id": "customDate",
  "binding": "customStringField",
  "header": "Target Date",
  "type": "date"
}

Type override behavior depends on the actual field values being parseable in the target format. A string field overridden to date will fail to parse non-date values gracefully.

Autocomplete and Suggestions

Certain field types support autocomplete suggestions as you type. The suggestion system provides real-time matching from the Polarion database.

Feature	Description
Fuzzy search	Matches values with minor typos or spelling variations
Wildcard search	Use `` for partial matching (e.g., `test*`)
Keyword filtering	All keywords in the query must match

Autocomplete behavior is controlled by project-level configuration properties. The suggestion API endpoint supports fuzzy search, wildcard search, and keyword-based filtering. See Suggestion and Autocomplete API for details.

Complete Example

A risksheet.json demonstrating all major supported field types:

{
  "columns": [
    {
      "id": "failureMode",
      "binding": "title",
      "header": "Failure Mode",
      "type": "text",
      "width": 220,
      "level": 1
    },
    {
      "id": "riskCategory",
      "binding": "riskCategory",
      "header": "Category",
      "type": "enum:riskCategory",
      "width": 130,
      "level": 2
    },
    {
      "id": "sev",
      "binding": "sev",
      "header": "Severity",
      "type": "rating:severity",
      "width": 80,
      "level": 2
    },
    {
      "id": "occ",
      "binding": "occ",
      "header": "Occurrence",
      "type": "rating:occurrence",
      "width": 80,
      "level": 2
    },
    {
      "id": "rpn",
      "binding": "rpn",
      "header": "RPN",
      "type": "int",
      "formula": "commonRpn",
      "width": 70,
      "level": 2
    },
    {
      "id": "riskScore",
      "binding": "riskScore",
      "header": "Risk Score",
      "type": "float",
      "width": 100,
      "level": 2
    },
    {
      "id": "mitigated",
      "binding": "mitigated",
      "header": "Mitigated",
      "type": "boolean",
      "width": 80,
      "level": 2
    },
    {
      "id": "dueDate",
      "binding": "dueDate",
      "header": "Due Date",
      "type": "date",
      "width": 120,
      "level": 2
    },
    {
      "id": "mitigationCost",
      "binding": "mitigationCost",
      "header": "Cost ($)",
      "type": "currency",
      "width": 100,
      "level": 2
    },
    {
      "id": "effort",
      "binding": "effortEstimate",
      "header": "Effort",
      "type": "duration",
      "width": 100,
      "level": 2
    },
    {
      "id": "affectedSystems",
      "binding": "affectedSystems",
      "header": "Affected Systems",
      "type": "multiEnum:affectedSystems",
      "width": 180,
      "level": 2
    }
  ],
  "formulas": {
    "commonRpn": "function(info){ var value = info.item['occ']*info.item['sev']; return value?value:null;}"
  },
  "ratings": {
    "severity": [
      { "id": "1", "name": "Negligible" },
      { "id": "2", "name": "Minor" },
      { "id": "3", "name": "Moderate" },
      { "id": "4", "name": "Significant" },
      { "id": "5", "name": "Catastrophic" }
    ],
    "occurrence": [
      { "id": "1", "name": "Remote" },
      { "id": "2", "name": "Low" },
      { "id": "3", "name": "Moderate" },
      { "id": "4", "name": "High" },
      { "id": "5", "name": "Very High" }
    ]
  },
  "enums": {
    "riskCategory": [
      { "id": "safety", "name": "Safety Risk" },
      { "id": "security", "name": "Security Risk" },
      { "id": "performance", "name": "Performance Risk" }
    ],
    "affectedSystems": [
      { "id": "braking", "name": "Braking System" },
      { "id": "steering", "name": "Steering System" },
      { "id": "powertrain", "name": "Powertrain" }
    ]
  }
}

Field Mapping — binding system and field resolution
System Fields — system-level bindings and constants
Data Types — column data type behavior and OData mapping
Column Type Reference — column definition properties
Enum Columns — enum field configuration
Date and Time Columns — temporal field handling
User Reference Columns — user field configuration
Culture and Localization Codes — locale settings affecting display

Sources

KB Articles

Multiple Downstream Work Item Types

Source Code

risksheet.json
ColumnTypeManager.java
PolarionAppConfigManager.java
GetSetUtil.java
AppConfigParser.ts

​Polarion-to-Risksheet Field Type Matrix

​Text and String Fields

​Numeric Fields

​Type Conversion Between Numeric Types

​Boolean Fields

​Date and Time Fields

​Enumeration Fields

​Single Enum

​Multi-Select Enum

​Duration Fields

​User Reference Fields

​Read-Only System Fields

​Type Override

​Autocomplete and Suggestions

​Complete Example

​Related Pages

Polarion-to-Risksheet Field Type Matrix

Text and String Fields

Numeric Fields

Type Conversion Between Numeric Types

Boolean Fields

Date and Time Fields

Enumeration Fields

Single Enum

Multi-Select Enum

Duration Fields

User Reference Fields

Read-Only System Fields

Type Override

Autocomplete and Suggestions

Complete Example

Related Pages