Skip to main content
Define the downstream work item type in the dataTypes section of your risksheet.json configuration: 
"dataTypes": {
  "risk": {
    "type": "risk"
  },
  "task": {
    "type": "riskControl",
    "role": "mitigates",
    "name": "Risk Control Measure",
    "zoomColumn": "taskTitle"
  }
}
The type specifies the work item type ID, role defines the link relationship, and zoomColumn identifies which column to focus when navigating to the task.

​
Display Task Information

Add a taskLink column to show the linked downstream items: 
{
  "headerGroup": "Mitigations",
  "header": "Task ID",
  "type": "taskLink",
  "id": "task"
}
The column id is critical—you’ll reference it when adding additional task property columns.

​
Show Task Properties

Display task properties using dot notation with the task column ID: 
{
  "headerGroup": "Mitigations",
  "header": "Task Title",
  "bindings": "task.title",
  "id": "taskTitle",
  "minWidth": 170
},
{
  "headerGroup": "Mitigations",
  "header": "Status",
  "bindings": "task.status"
},
{
  "headerGroup": "Mitigations",
  "header": "Assignee",
  "bindings": "task.assignee"
}
diagram
If your task column id is "issue", bindings become "issue.title", "issue.status", etc. The pattern is always <taskId>.<property>.

​
Control Data Source

​
Load from Specific Location

Use document, project, and query parameters to control where tasks are loaded: 
"task": {
  "type": "task",
  "role": "mitigates",
  "name": "Task",
  "zoomColumn": "taskTitle",
  "document": "Risks/Tasks",
  "project": "safety_analysis",
  "query": "status:(open OR in_progress)"
}

​
Load from Multiple Projects

Starting with version 23.7.0, you can load tasks from multiple projects: 
"task": {
  "type": "task,issue",
  "role": "mitigates",
  "name": "Task",
  "zoomColumn": "taskTitle",
  "projects": "ProjectA,ProjectB"
}

​
Configure Task Creation

​
Create in Current Document

Force new tasks to be created in the current RISKSHEET document: 
"task": {
  "type": "task",
  "role": "mitigates",
  "name": "Task",
  "zoomColumn": "taskTitle",
  "createInCurrentDocument": true
}

​
Create in Specific Document

Starting with version 24.8.1, specify a target document for new tasks while loading from any location: 
"task": {
  "type": "task",
  "role": "mitigates",
  "name": "Task",
  "zoomColumn": "taskTitle",
  "project": "safety_analysis",
  "query": "status:open",
  "createInDocument": "Risks/Mitigations"
}

​
Multi-Project Task Creation

Starting with version 25.3.1, users can choose which project and type to use when creating tasks in multi-project configurations: 
{
  "header": "Task Project",
  "bindings": "task.project",
  "readOnly": true
},
{
  "header": "Task Type",
  "bindings": "task.type",
  "readOnly": true
}
Multi-project task picker If no selection is made, the first project and type in the list will be used by default.
In multi-project configurations, the type column displays work item type names consistently, but the type picker aggregates types from all configured projects.

​
Verification

After configuration, your RISKSHEET should display:
  • A task ID column showing linked downstream items
  • Additional columns displaying task properties (title, status, assignee, etc.)
  • The ability to create new tasks from the grid (unless disabled)
  • Tasks filtered according to your document/project/query settings
Test by creating a new task from a risk item—it should appear in the configured target location.

​
See Also