Looking to get all issues by initiative

Questions & Answers
2

Hello

eazyBI has an option to build new hierarchies in Issue dimension. You can build new Issue hierarchy over basic levels Parent>Sub-task or Epic>Parent>Sub-task. You would like to pick one and then build some more levels above.

eazyBI requires a separate custom field with Issue key for any level above default levels. In your case, you should create new custom fields for Theme and Initiative. You could create those custom fields with Issue link import.

For hierarchy: Theme>Initiative>Epic>Parent>Sub-task, you should define new link custom fields for Initiative and Theme. You could use any JIRA custom field for them, if you do have one. For example, JIRA Portfolio has a Parent link, you can use for one additional level.

Here are several tips how to define link custom fields for issue hierarchy with eazyBI option Issue link import:

  • each issue should have only one issue key on any level above (no multiple values)
  • import any level issue key for issues one level below
  • Issues could be linked with either Inward or Outward links. Please check issue link direction in JIRA Administration section Issue linking. Use correct directions and namings.
  • Issue type in link configuration filters linked issues by Issue type

For our example,
You should import one issue key of Initiative for Epic issues
You should import one issue key of Theme for Initiative issues

Please use correct code and sequence for update_from_issue_key parameter for each link custom fields used in hierarchy. This parameter is the key for building hierarchy. For each level update_from_issue_key should address custom field or default field of the next (below) level.

Let’s define new link custom fields and hierarchy for our example:
Any Initiative issue has a link to one Theme issue with outward issue link “has Theme”. You should see this link in any Initiative issue. This definition describes linked Theme issue:

[jira.customfield_theme]
name = "Theme"
outward_link = "has Theme"
issue_type = "Theme"
update_from_issue_key = "customfield_initiative"

Any Epic issue has a link to one Initiative issue with outward issue link “has Initiative”. You should see this link in any Epic issue. This definition describes linked Initiative issue:

[jira.customfield_initiative]
name = "Initiative"
outward_link = "has Initiative"
issue_type = "Initiative"
update_from_issue_key = "epic_key"

Please use your issue link names and directions in definitions above.

You do not need to define default levels as custom fields. You can address new levels and default levels in Issue hierarchy:

[[jira.issue_hierarchies]]
name = "Theme"
all_member_name = "All Issues by themes"
levels = [
  {name="Theme",key_column="customfield_theme",issue_type="Theme"},
  {name="Initiative",key_column="customfield_initiative",issue_type="Initiative"},
  {name="Epic",key_column="epic_key"},
  {name="Parent",key_column="epic_parent_key"},
  {name="Sub-task",key_column="subtask_key"}
]