Hi,
We are trying to develop a hierarchy in EazyBi based on parent links, however we cannot get it working. When we run the last query in EazyBI no hierarchy is developed (based on no hierachies when applying issue type dimension). Hope that you can help.
We have the below hierachies in JIRA connected via parent links:
SAFe epic (portfolio)
SAFe capability (large solution)
SAFe feature (porgram)
Story
We have done it via the two steps mentioned in EazyBI documentation - https://docs.eazybi.com/display/EAZYBIJIRA/Additional+Issue+hierarchies:
1. Created custom field in JIRA
Created a custom field in JIRA with the name “Initiative” and under description we have included below query (Instead of NNNNN we have included the issue ID for parent link (17003) which we found as the last digit in the browser link when clicking on parent link in custome fields in JIRA).
if (issue.get(“customfield_17003”) != null) {
return issue.get(“customfield_17003”).getKey();
}
else {
return “”;
}
–>
2. Added custom field definition and hierachy difinition to advanced settings in EazyBI
27700 is referring to the last digits in the browser line when cliking on the initative customfield in JIRA and then we included the name of the levels.
We are assuming that the problems lies in the statements with “key”. We have just written “key”, but perhaps a value should be included here instead?
#Precalculated custom field with Parent link key or Jira Portfolio Parent link field
[jira.customfield_27700]
data_type = “string”
check_calculated_value = true
update_from_issue_key = “SAFe EPIC (Portfolio)_key”
[[jira.issue_hierarchies]]
name = “Initiative”
all_member_name = “All Issues by Initiative”
levels = [
{name=“Initiative”,key_column=“customfield_27700”,issue_type=“Initiative”},
{name=“SAFe EPIC (Portfolio)”,key_column=“SAFe EPIC (Portfolio)_key”},
{name=“SAFe Capability (Large Solution)”,key_column=“SAFe Capability (Large Solution)_key”},
{name=“SAFe Feature (Program)”,key_column=“SAFe Feature (Program)_key”},
{name=“Story”,key_column=“Story_key”}
]
Also tried below query instead, also without any luck:
#Precalculated custom field with Parent link key or Jira Portfolio Parent link field
[jira.customfield_27700]
data_type = “string”
check_calculated_value = true
update_from_issue_key = “epic_key”
[[jira.issue_hierarchies]]
name = “Initiative”
all_member_name = “All Issues by Initiative”
levels = [
{name=“Initiative”,key_column=“customfield_27700”,issue_type=“Initiative”},
{name=“Epic”,key_column=“epic_key”},
{name=“Parent”,key_column=“epic_parent_key”},
{name=“Sub-task”,key_column=“subtask_key”}
]
Hope you can help.
Br. Karoline
strong text