Task Link Columns - Nextedy Documentation

Column Definition Properties

Core Properties

Property	Type	Default	Description
`binding`	`string`	Required	Polarion field ID used to store the task link reference. This field stores the task work item identifier.
`type`	`string`	Auto-detected	Must be `taskLink` for task link columns. Auto-detected from the Polarion field type if not specified.
`header`	`string`	Required	Display text shown in the column header.
`id`	`string`	Auto-generated	Unique identifier for the column. Auto-generated from `header` or `binding` if not specified.
`width`	`number`	See application	Column width in pixels.
`isTaskLink`	`boolean`	`false`	Marks the column as a task link column. Set to `true` to enable task-specific behavior. This flag is equivalent to setting `type` to `taskLink`.
`level`	`number`	Not set for task columns	Hierarchical level at which this column appears. Task-level columns typically do not have a level assigned.
`readOnly`	`boolean`	`false`	Controls whether the column is editable. Automatically set to `true` for formula columns and when permissions deny modification.
`filterable`	`boolean`	`true`	Controls whether users can filter the grid by values in this column.
`canCreate`	`boolean`	`true`	Controls whether users can create new task items directly from the cell. When `true`, the autocomplete dropdown includes an option to create a new task.

Link Field Convention

Every task link column has an associated link field identified by appending _link to the binding name. This _link suffix field stores the hyperlink URL to the linked work item:

Field	Purpose	Example
`taskId`	Stores the task work item identifier	`MIT-015`
`taskId_link`	Stores the hyperlink reference to the task	Polarion work item URL

When a new task is created, Risksheet automatically sets both the taskColumn value and the taskColumn_link field to maintain synchronized references.

Task Data Type Configuration

Task link columns depend on the dataTypes.task configuration in risksheet.json. This section defines the work item type, link role, and behavior for all task-related operations.

Property	Type	Default	Description
`dataTypes.task.type`	`string`	None	Polarion work item type for tasks (e.g., `action`, `mitigationTask`). Evaluated through expression evaluation for dynamic values.
`dataTypes.task.role`	`string`	None	Link role used when creating relationships between risk items and tasks. Evaluated through expression evaluation.
`dataTypes.task.name`	`string`	`"Task"`	Display name for the task type shown in context menus and UI labels.
`dataTypes.task.showInMenu`	`boolean`	`true`	Controls whether task creation options appear in the context menu and toolbar.
`dataTypes.task.zoomColumn`	`string`	None	Column binding that receives focus after a new task is created. Determines which nested column the cursor moves to for immediate editing.
`dataTypes.task.customQuery`	`string`	None	Additional Polarion query to filter which tasks are retrieved. Applied when `nextedy.risksheet.applyQueryOnTasks` is `true`.

{
  "dataTypes": {
    "task": {
      "type": "mitigationAction",
      "role": "mitigates",
      "name": "Mitigation Action",
      "showInMenu": true,
      "zoomColumn": "taskTitle"
    }
  }
}

Single vs. Multi-Project Configuration

Property	Type	Description
`project`	`string`	Single project ID for task items. Use when all tasks belong to one project.
`projects`	`array`	Array of project IDs for multi-project task configurations.

Having a Task project column visible in the Risksheet configuration can cause duplication errors when copy-pasting existing tasks between rows (Ctrl+C / Ctrl+V). The workaround is to remove the Task project column from the configuration. For single-project task configurations, use project (singular) instead of projects (plural) in the dataTypes section.

Task Column Identification

The grid identifies which column holds the task identifier through the taskColumn property in grid settings:

Property	Type	Default	Description
`taskColumn`	`string`	None	Binding name of the column that stores the task identifier. Required for task creation, removal, and autocomplete operations.

This property is essential for all task management operations. Without it, add task, remove task, and task autocomplete functions will not work.

Task Creation Behavior

When you create a new task (via context menu or toolbar), Risksheet follows one of two paths depending on whether the risk item already has tasks:

First Task on a Risk Item

A unique task ID is generated automatically using the ID generator.
The task ID is stored in the taskColumn field.
The corresponding _link field is populated with the work item reference.
The cursor focuses on the zoomColumn (if configured) for immediate editing.
The operation is recorded for undo support.

Additional Tasks on a Risk Item

The current row record is cloned.
Task-level fields are cleaned (task ID, link fields, readonly flags, and all columns marked as task attributes).
Multi-enum columns are initialized to empty arrays to prevent undefined values.
A unique task ID is generated for the new task.
The new row is inserted immediately after all existing sibling tasks (rows sharing the same systemItemId).
The operation is recorded for undo support.

Task Removal Behavior

Task removal operates with context-aware logic based on whether the risk item has single or multiple tasks:

Single Task Removal

When the risk item has only one task, removing it clears all task-related fields from the work item record rather than deleting the entire row. The risk item row is preserved. Fields cleared include:

Task column value and its _link field
All columns marked as task attributes (isTaskAttrib)
Task-level link references

Multi-Task Removal

When the risk item has multiple tasks (detected by checking if adjacent rows share the same systemItemId), removing a task deletes the entire row from the grid. The row ID is marked with a ;* suffix before deletion for processing during save.

Permission Checks

Task removal validates permissions before executing:

Permission Check	Condition	Effect
Grid readonly	`readonly` is `true`	Task removal blocked
Downstream readonly	`downstreamReadonly` is `true` AND `systemReadOnly` flag is set	Task removal blocked
Task readonly	`systemTaskReadOnly` flag is set on the row	Task removal blocked

All task removal operations are fully undoable.

Autocomplete and Search

Task link columns provide autocomplete functionality for linking existing tasks:

Feature	Behavior
Uniqueness validation	Prevents duplicate task assignments to the same risk item. Displays error: “This item is already linked to selected row.”
New task mode	When the task ID is empty or starts with `*` (unsaved), the nested title column provides task autocomplete for finding existing tasks.
Existing task mode	When a task ID is assigned, nested columns switch to regular text editing mode.
Query factory support	Custom `queryFactory` functions can filter autocomplete suggestions. Register factories via `window.risksheet.queryFactories`.

Nested Task Columns

Task link columns typically have nested sub-columns that display properties of the linked task. Nested columns are identified as task attributes:

Property	Type	Description
`isTaskAttrib`	`boolean`	Marks a column as a task attribute. Task attribute columns display data from the linked task work item rather than the parent risk item.

Task attribute columns are automatically cleared when creating new tasks and are subject to task-level readonly permissions (systemTaskReadOnly and systemTaskReadOnlyFields).

Readonly Protection

Task link columns respect multiple layers of readonly protection:

Property	Type	Default	Description
`systemReadOnly`	`boolean`	From Polarion permissions	Marks entire items as non-editable based on permissions or item state.
`systemReadOnlyFields`	`array`	From Polarion permissions	Lists specific field names that are non-editable for an item.
`systemTaskReadOnly`	`boolean`	From Polarion permissions	Marks linked task items as non-editable. Prevents task editing and removal regardless of other settings.
`systemTaskReadOnlyFields`	`array`	From Polarion permissions	Lists specific fields that are non-editable in linked task items.
`downstreamReadonly`	`boolean`	`false`	Global setting that makes all downstream linked items read-only to prevent edits to items from other documents.

Right-clicking a task link cell provides task-specific menu options:

Menu Action	Availability	Description
Open Task Item	When cell contains a valid task link	Opens the task work item in Polarion’s item editor. Menu label uses `dataTypes.task.name` if configured.
Add Task	Grid is not readonly; `downstreamReadonly` allows creation	Creates a new task for the current risk item.
Remove Task	Grid is not readonly; task-level permissions allow removal	Removes the task (clears fields or deletes row depending on task count).

Export Behavior

Excel Export

Task link columns export as plain text, with HTML link markup stripped to produce clean text values. Multi-task rows are exported as separate rows in the Excel output.

PDF Export

Task link columns render in PDF using the renderDataCell function, which resolves the link label property for display. Use exportSubTable or exportDownstreamTable to export task data as separate tables in the PDF output.

Complete Example

{
  "columns": [
    {
      "binding": "mitigationTaskId",
      "header": "Mitigation",
      "type": "taskLink",
      "width": 120,
      "canCreate": true
    },
    {
      "binding": "mitigationTitle",
      "header": "Task Title",
      "isTaskAttrib": true,
      "width": 250
    },
    {
      "binding": "mitigationStatus",
      "header": "Status",
      "isTaskAttrib": true,
      "type": "workflow",
      "width": 100
    },
    {
      "binding": "mitigationAssignee",
      "header": "Assignee",
      "isTaskAttrib": true,
      "width": 120
    }
  ],
  "dataTypes": {
    "task": {
      "type": "mitigationAction",
      "role": "mitigates",
      "name": "Mitigation Action",
      "showInMenu": true,
      "zoomColumn": "mitigationTitle"
    }
  }
}

This configuration creates a task link column for mitigation actions with three nested columns showing the task title, workflow status, and assignee. New tasks are created as mitigationAction work items linked via the mitigates role.

Item Link Columns for upstream traceability columns linking to requirements and hazards
Multi-Item Link Columns for columns displaying multiple linked items per cell
Column Type Reference for the complete list of column types
Data Types for the full dataTypes configuration reference
Levels Configuration for hierarchical level settings that interact with task columns

Sources

KB Articles

Support Tickets

Source Code

SheetConstants.ts
RemoveTaskCommand.ts
RiskSheetContextMenu.ts
CellEditorFormatter.ts
RisksheetViewServlet.java

​Column Definition Properties

​Core Properties

​Link Field Convention

​Task Data Type Configuration

​Single vs. Multi-Project Configuration

​Task Column Identification

​Task Creation Behavior

​First Task on a Risk Item

​Additional Tasks on a Risk Item

​Task Removal Behavior

​Single Task Removal

​Multi-Task Removal

​Permission Checks

​Autocomplete and Search

​Nested Task Columns

​Readonly Protection

​Context Menu Actions

​Export Behavior

​Excel Export

​PDF Export

​Complete Example

​Related Pages

Column Definition Properties

Core Properties

Link Field Convention

Task Data Type Configuration

Single vs. Multi-Project Configuration

Task Column Identification

Task Creation Behavior

First Task on a Risk Item

Additional Tasks on a Risk Item

Task Removal Behavior

Single Task Removal

Multi-Task Removal

Permission Checks

Autocomplete and Search

Nested Task Columns

Readonly Protection

Context Menu Actions

Export Behavior

Excel Export

PDF Export

Complete Example

Related Pages