Reporting on Structure for Jira (from almworks)

Hi,

Here follows an example of how to build the dimension using the Structure board name. For this example to work, you need to use a scripted field of the Scriptrunner add-on accessing the list of structures where an issue belongs to (Text Field):

package examples.docs.structure

import com.almworks.jira.structure.api.permissions.PermissionLevel
import com.almworks.jira.structure.api.StructureComponents
import com.onresolve.scriptrunner.runner.customisers.PluginModule
import com.onresolve.scriptrunner.runner.customisers.WithPlugin

@Grab(group = 'com.almworks.jira.structure', module = 'structure-api', version = '16.0.0')
@WithPlugin("com.almworks.jira.structure")
@PluginModule
StructureComponents structureComponents

def structureManager = structureComponents.getStructureManager()
def structures = structureManager.getViewableStructuresWithIssue(issue.id)
def structureList = []
structures.each {structure ->
		structureList.add(structure.name)
}
structureList.join(",")

There might be other and better ways to generate the list of Structure names for an issue. Once we have the list of Structure names in a custom field, use the following advanced settings to import the Structure names as a dimension in eazyBI (NNNNN is the custom field ID in Jira):

[jira.customfield_NNNNN]
data_type = "string"
dimension = true
multiple_values = true
split_by = ","

Best regards,
Janis, eazyBI support

1 Like