# Getting linkedIssuesInQuery in eazyBI

**URL:** <https://community.eazybi.com/t/getting-linkedissuesinquery-in-eazybi/11498>\
**Category:** Questions & Answers\
**Tags:** calculatedmembers, mdx\
**Created:** [January 17, 2023, 11:20am UTC](https://community.eazybi.com/t/getting-linkedissuesinquery-in-eazybi/11498 "2023-01-17T11:20:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![spain93](https://community.eazybi.com/letter_avatar_proxy/v4/letter/s/d26b3c/32.png) [@spain93](https://community.eazybi.com/u/spain93)\
**Post date:** [January 17, 2023, 11:20am UTC](https://community.eazybi.com/t/getting-linkedissuesinquery-in-eazybi/11498/1 "2023-01-17T11:20:08Z")

</div>

Hi all,

I have the following JQL and imported the link already.  
issuetype = Incendent AND project in (x, y) AND issue in linkedIssuesInQuery(“issuetype=Incendent and project in (a, b)”, relates)

Does anybody know how I can do that in eazyBI?

I appreciate your help!  
Thomas

---

<div class="post-metadata">

**Author:** ![janis.plume](https://community.eazybi.com/user_avatar/community.eazybi.com/janis.plume/32/8826_2.png) [@janis.plume](https://community.eazybi.com/u/janis.plume)\
**Post date:** [January 19, 2023, 1:02pm UTC](https://community.eazybi.com/t/getting-linkedissuesinquery-in-eazybi/11498/2 "2023-01-19T13:02:27Z")

</div>

Hi Thomas,

You are welcome to the eazyBI community!

The solution should be implemented in eazyBI with the following:

1. Configure and import the issue link: [Import issue links](https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/import-issue-links)

The link configuration can limit the issue type for the linked issue and the link name, but it cannot specify the project for the linked issue.

1. A custom measure is needed to check if the Incident from X,Y projects has link to an Incident it AB project.

I checked this solution with a similar configuration where I imported the Bugs linked to a Story:

```auto
[jira.customfield_bugs]
name = "Bugs"
outward_link = "causes"
issue_type=["Bug"]
multiple_values = true
dimension = true

```

I created the following custom measure to count for each issue the Linked bugs from another project:

```auto
CASE WHEN
[Measures].[Issues created]>0
THEN
NonZero(Count(
  Filter(
    [Issue].[Issue].GetMembersByKeys(
      [Issue].CurrentMember.get('Bugs')
    ),
    [Issue].CurrentMember.Parent.Name="DEMO Beta"
    
  )
))
END

```

My test report looked like this:

 ![image](https://community.eazybi.com/uploads/default/original/2X/1/1d73616b038c755f56a83d492ca3697dc8db758c.png)

Kindly,  
Janis, eazyBI support