All eazyBI for Jira eazyBI for Confluence Private eazyBI

Status Category
eazyBI for Jira

Works only for eazyBI on Jira Cloud

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

Internal name

stcatname

Display nameStatus Category Name
Data type

string 

Dimension

Additional advanced settings

json_fields = ["statusCategory"] 

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 codeKeep the opening and closing quotation marks. ''', do not delete them.