To understand what data are visible on the risksheet, you need to understand the concept of Levels


(Click on the screenshot for details)


The Level 1 and Level 2 columns are connected to a single work item - by default Risk Item.

I.e. even though it looks like the Level 2 items are children of Level 1 items - because the table looks like Cause is a child of Failure Mode - in reality, this is achieved by merging the Level 1 columns.  We will explain it more on the example bellow.


The Level 3 columns are connected to a down-stream / child items.


Default Configuration Example


Take a default configuration as an example, Levels configuration in risksheet.json specifies that the Level 1 columns shall be merged according to a column  "failureMode" (See the "controlColumn" property), this means that for example Severity column shall be merged in the same way as Failure mode column. 


This means that:

  1. The Failure mode column  (controlColumn) will be merged, i.e. all the risk items that have the same "failure mode" value, will be grouped together and cells will be merged
  2. All the additional level-3 columns - e.g. severity - will be merged as well - supposing the values are the same, which should be the case (based on FMEA standard).


The level 2 columns, shall be merged according to system column "systemItemId", which holds the risk work item id. This effectively means that level 2 columns shall not be merged at all.


The level 3 columns are not merged at all as well.


In addition to that, you can see two other properties:

  • The zoomColumn defines, where shall the cursor appear when you click "New Failure Mode" resp "New Cause" or "New Task".
  • The name property holds the label that should be visible in the actions "New ...", "Delete ...", ...


"levels": [
    {
      "name": "Failure mode",
      "controlColumn": "failureMode",
      "zoomColumn":"failureMode"
    },
    {
      "name": "Cause",
      "zoomColumn": "causes",
      "controlColumn": "systemItemId"
    },
    {
      "name": "Task",
      "zoomColumn": "taskTitle"
    }
  ],


Data Types


You can see above that the "levels" configuration does not define what work item types represent "Risk" or "Task" work items. This is defined in dataTypes section


"dataTypes": {
    "risk": {
      "type": "risk"
    },
    "task": {
      "type": "task",
      "role": "mitigates"
    }
  },

Here there are just two sections  - the first "risk" section is connected to Level 1 and Level 2 columns. The second "task" section defines the Level 3 column item type.


So to configure what work item is a risk item (connected with Level 1 and Level 2 columns) change the type property of "risk" section.


To configure what work item type shall represent the down-stream objects (usually tasks), configure the type property of "task" section. As you can see, you can also set the role property to configure the work item link role used between "task" and "risk".