Linked tickets in Jira SM

I’m creating a cube in EazyBi to analyze a Jira SM project.

I especially need to be able to retrieve data based on a ticket type (HotFix) and see if it has any linked incidents. Currently it shows it to me under the names “related to” or “automated in” or “created”.

What field would give me that data? I searched for it but I can’t find it. The one I know, “linked issues”, doesn’t give me anything. I’m attaching an example image.

You can do this in Jira with next syntax:
Issuetype=Hotfix and issueLinkType in (related to,automated in,created)

In EazyBI you can make next in Settings->Advanced settings

[jira.customfield_linked_issues]
name = “Hotfix with links”
outward_link = [“relates to”,“automated in”,“created”]
multiple_values = true
dimension = true

You then check the field “Hotfix with links” or any other name you have given it in Source data->edit-> Issue links Custom fields. Import your data and the you wil see it in you measures where you can use it.

I’m going to try what you told me,

Thank you very much!

Hi,

@fcojnav78 thanks for posting your question & @_P3 thanks for the answer, much appreciated! :slightly_smiling_face:

the only thing to keep in mind is to check your link directions (outward/inward) and make sure they are defined correctly in your import options.

Read more about issue links in our documentation here: Import issue links

For inspiration, you can check this sample report that shows how to analyze linked issues (where “Bugs” represents the issue link): Stories with Bugs details - Issues - eazyBI Demo Training - eazyBI

Hope this helps,
Marita // support@eazybi.com