Value of custom field was

janis.plume · December 10, 2021, 2:47pm

Hi, Robert

Let me assure that the collection of the group picker field history is not quite trivial

The challenge is that eazyBI can support only the value change import for single-value fields. The group picker fields in Jira issue history are recorded as if they were the multiple value field even if you have the single selection group picker:

A couple of steps are needed to record the history correctly.

Add the configuration parameter explicitly telling that this field is not multiple value field:

[jira.customfield_11222]
multiple_values=false
separate_table=true
changes=true

The import of history now will work. Still, you will see that additional members will be created in the dimension with the brackets (those members are generated from the history records, as those records look like arrays):

Now, we need to preprocess the history records with the custom Javascript code to eliminate the brackets:

issue.changelog.histories.forEach(function(history){
    history.items.forEach(function(historyItem){
      if (historyItem.field == "Group Assignee") {
        fs=historyItem.fromString;
        if (fs) {
          historyItem.fromString=fs.substr(1,fs.length-2);
        }
        ft=historyItem.toString;
        if (ft) {
          historyItem.toString=ft.substr(1,ft.length-2);
        }
      }
    });
});

Use the correct name (not ID) of the custom field in the code. The code is needed in the additional options of the data source:

Now, after a clean data import (with empty cube option), the result should be fine:

Kindly,
Janis, eazyBI support