Multi-level cascading field
eazyBI for Jira
Import multi-level cascading field from the Jira app provided by Sourcesense. In defining the settings, use your multi-level custom field ID instead of NNNNN
. Parameters may vary depending on how many levels should be defined.
Account-specific calculated field
Account specific calculated fields are defined in Source Data → Import options.
Settings for the new field
Internal name | mlfield_n |
---|---|
Display name | MultiLevel Fieldname |
Data type | string |
Dimension | ✓ |
Additional advanced settings | json_fields = ["customfield_NNNNN"] #this line is mandatory |
Custom JavaScript code:
var cfList = []; if (issue.fields.customfield_NNNNN) { for (var i=0; i < issue.fields.customfield_NNNNN.length; i++) { var cfVal= issue.fields.customfield_NNNNN[i].value; cfList.push(cfVal) } } if(cfList){ return _.uniq(cfList).join(","); }
Global calculated field
Global calculated fields are defined in eazyBI advanced settings.
Here are the settings for the new field definitions. You should insert the JavaScript (the code given above) below the line // Insert here the Custom JavaScript code
. Keep the opening and closing quotation marks. '''
, do not delete them.
[jira.customfield_mlfield_n] data_type = "string" name = "MultiLevel Fieldname" #use this line to pick a name for new calculated field json_fields = ["customfield_NNNNN"] #this line is mandatory dimension = true levels = ["Level 1","Level 2","Level 3"] split_by = "," javascript_code = ''' // Insert here the Custom JavaScript code '''