Status Category

eazyBI for Jira

Imports the name of Status Category in eazyBI for Jira Cloud. 

Some default Jira fields are returned in the JSON view but can't be used by default when calculating other calculated fields using JavaScript code. In such cases, the additional line json_fields = ["JiraFieldID"]   should be used in the advanced settings to access the field during data import.

Account-specific calculated field

Account specific calculated fields are defined in Source Data → Import options.

Settings for the new field

Custom JavaScript code:

if (issue.fields.statusCategory) {
  return issue.fields.statusCategory.name;
}

Another example of JavaScript code is to retrieve the statusCategory attribute's name from the issue status field. In this example, the additional advanced settings would not be necessary as the status field is being detected by eazyBI automatically. This code also works for eazyBI customers on Jira Data Center

if (issue.fields.status.statusCategory ) {
  return issue.fields.status.statusCategory.name;
}

Global calculated field

[jira.customfield_stcatname]
name = "Status Category Name"
data_type = "string"
dimension = true
json_fields = ["statusCategory"] #this line is mandatory
javascript_code = '''
   // Insert here the Custom JavaScript code 
'''

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.