Issues from "none" branch disappearing in Level hierachy

[cybertachikoma]

Hello,

I’m sorry, I’m going to decribe complicated case. I think It fails with bug in the end.

My report uses a hierarchy:

''' 
[jira.customfield_theme]
name = "THEME"
inward_link = "is contained in"
issue_type = "Theme"
update_from_issue_key = "customfield_init"


[jira.customfield_init]
name = "INIT"
inward_link = "is contained in"
issue_type = "Initiative"
update_from_issue_key = "customfield_change"

[jira.customfield_change]
name = "CHANGE"
inward_link = "is contained in"
issue_type = "Change"
update_from_issue_key = "customfield_cte"

[jira.customfield_cte]
name = "CTE"
inward_link = "is contained in"
issue_type = "CTE"
update_from_issue_key = "epic_key"

[[jira.issue_hierarchies]]
name = "THEME-Initiative-Change-CTE"
all_member_name = "All Issues by THEME"
levels = [
  {name="THEME",key_column="customfield_theme",issue_type="Theme"},
  {name="INIT",key_column="customfield_init",issue_type="Initiative"},
  {name="CHANGE",key_column="customfield_change",issue_type="Change"},
  {name="CTE",key_column="customfield_cte",issue_type="CTE"}
]

It works great

Next, report contains “measure0”:

(
[Measures].[Issues created],
[Issue Type].[CTE],
[ifStructure].[PI_2023.1]
)

I believe, you don’t want want to know what it counts, but I can tell you that it works good.

My story is about “none” hierarchy:

Most time it works great as well. We can see last issue types in hierarchy called “CTE”

But sometimes, after collapse|expand of root grouping element

“none” hierarchy of report changes to this…

and the job of “measure0” algorithm breaks as well

apart from

For other branches, when Theme-Init-Change-CTE link exists, everything works as expected.

Need help…

[martins.vanags]

Hi,

Try using outward_link to define the fields for hierarchy levels.
See the last post from this thread:

Custom hierarchy for issues

Hello @oskars.laganovskis Thanks a lot for responding. Tried the below and it works. I had help from @roberts.cacus as well. I am detailing the formula that was implemented so that it benefits a lot of folks who will be looking for a solution. [jira.customfield_istory] name = "Implements Story" outward_link = "implements" issue_type = "User Story" [jira.customfield_ifeature] name = "Implements Feature" outward_link = "implements" issue_type = "New Feature" update_from_issue_key = "customfield…

Martins / eazyBI

[cybertachikoma]

Hi, I’ve tried a test case, here it’s description:

There’re 3 issues to import. They’re from one Project.

issue in (T01_OMNI-588, T01_OMNI-828, T01_OMNI-846)

root level issue is T01_OMNI-588,
type: “Change”
linkType: contains T01_OMNI-828, T01_OMNI-846

leafs are T01_OMNI-828, T01_OMNI-846
type: “CTE”
linkType: is contained in T01_OMNI-588

You can see expected behaviour made by config with “inward_link”

[jira.customfield_change]
name = "CHANGE"
inward_link = "is contained in"
issue_type = "Change"
update_from_issue_key = "customfield_cte"

[jira.customfield_cte]
name = "CTE"
inward_link = "is contained in"
issue_type = "CTE"

[[jira.issue_hierarchies]]
name = "Change-CTE"
all_member_name = "CHANGE-CTE"
levels = [
  {name="CHANGE",key_column="customfield_change",issue_type="Change"},
  {name="CTE",key_column="customfield_cte",issue_type="CTE"}
]

Next I’ve created hierarchy config, that looks like you’ve recommended with “outward_link”:

[jira.customfield_nchange]
name = "NCHANGE"
outward_link = "contains"
issue_type = "Change"
update_from_issue_key = "customfield_ncte"

[jira.customfield_ncte]
name = "NCTE"
outward_link = "contains"
issue_type = "CTE"

[[jira.issue_hierarchies]]
name = "NCHANGE-NCTE"
all_member_name = "NCHANGE-NCTE"
levels = [
  {name="NCHANGE",key_column="customfield_nchange",issue_type="Change"},
  {name="NCTE",key_column="customfield_ncte",issue_type="CTE"}
]

But it works not as I’ve expected

Cant’ find out
-what is “none” branch,
-why leafs are listed by comma

[martins.vanags]

@cybertachikoma

This has to be the right code for your custom hierarchy:

[jira.customfield_theme]
name = "THEME"
inward_link = "is contained in"
issue_type = "Theme"
update_from_issue_key = "customfield_init"

[jira.customfield_init]
name = "INIT"
inward_link = "is contained in"
issue_type = "Initiative"
update_from_issue_key = "customfield_change"

[jira.customfield_change]
name = "CHANGE"
inward_link = "is contained in"
issue_type = "Change"

[[jira.issue_hierarchies]]
name = "THEME-Initiative-Change-CTE"
all_member_name = "All Issues by THEME"
levels = [
  {name="THEME",key_column="customfield_theme",issue_type="Theme"},
  {name="INIT",key_column="customfield_init",issue_type="Initiative"},
  {name="CHANGE",key_column="customfield_change",issue_type="Change"},
  {name="CTE",key_column="subtask_parent_key"},
  {name="Subtask",key_column="subtask_key"}
]

Martins / eazyBI