# Import wiki page link into eazybi

**URL:** <https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631>\
**Category:** Questions & Answers\
**Tags:** javascript, remotelink, jira, confluence\
**Created:** [June 10, 2020, 2:51pm UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631 "2020-06-10T14:51:49Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rajatgupta](https://community.eazybi.com/letter_avatar_proxy/v4/letter/r/fbc32d/32.png) [@Rajatgupta](https://community.eazybi.com/u/Rajatgupta)\
**Post date:** [June 10, 2020, 2:51pm UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/1 "2020-06-10T14:51:49Z")

</div>

hi ,

Is it possible to import linked confluence page on a ticket as ‘Wiki Page’ and be displayed on the reports?

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

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [June 16, 2020, 9:27am UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/2 "2020-06-16T09:27:33Z")

</div>

Hi @Rajatgupta,

eazyBI does not have default support for Confluence link import into eazyBI. But you can use **JavaScript calculated customfield** ([JavaScript calculated custom fields](https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields)) for this import. The Confluence URL will be imported as a dimension and property.

1.Open eazyBI advanced settings and use the following custom field definition:

```
##Confluence all links
[jira.customfield_remotelink]
data_type = "string"
name = "Wiki page"
dimension = true
multiple_values = true
split_by = ","
javascript_code = '''
var newlist = new Array();
getDocument("issue/"+ issue.key + "/remotelink", {ignoreErrors: [404]}, function(result){
  if (result) {
    for (var i = 0; i < result.length; i++) {
     let relationship = result[i].relationship;
      if(relationship){
        newlist.push(result[i].object.url);
      }
    }; issue.fields.customfield_remotelink = newlist.join(",");
  }
});
'''

```

You can use a bit different name instead of **Wiki page**.

2.Open Jira import options and select custom field **Wiki page** as a dimension or a property - then run data import again.  
3.The report you will be able to create can look like this:

- Using it as dimension:  
 ![Dimension-wiki-page.png](https://community.eazybi.com/uploads/default/original/2X/6/63f7d7ecc8b5387d3d1cfefca3dae628852a90e3.png)
- Using it as property:  
 ![Wiki-properties.png](https://community.eazybi.com/uploads/default/original/2X/a/a9ab92f628fac575f2f5b96bf881408629fc9baf.png)

best,  
Gerda // [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![thaynemunson](https://community.eazybi.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@thaynemunson](https://community.eazybi.com/u/thaynemunson)\
**Post date:** [March 31, 2022, 7:01pm UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/3 "2022-03-31T19:01:57Z")

</div>

Hi Gerda. Is there a way to make the Wiki page link active? When I hover over the link I only get Drill Across or Remove options when what I really want is ‘Go To Source’.  
Thanks,  
Thayne Munson

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [April 1, 2022, 8:28am UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/4 "2022-04-01T08:28:02Z")

</div>

Hi @thaynemunson ,  
By default, it won’t be possible but you could try to create a new measure as a hyperlink.  
Here is an example using Issue key in report as hyperlink: [List of issues in progress - Issues - Jira Demo - eazyBI](https://eazybi.com/accounts/1000/cubes/Issues/reports/281703-list-of-issues-in-progress)

For “Wiki pages” it could look like this:

```auto
CASE WHEN
[Wiki page].CurrenthierarchyMember.level.name = "Wiki page"
AND
[Wiki page].CurrenthierarchyMember.name <> "(none)"
THEN
"[Wiki URL]"
||"("
||Cast([Wiki page].CurrentHierarchyMember.Name as string)
||")"
END

```

Use markdown formatting for the measure to display it as link: [Calculated measures and members](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Formatting)

In the report:

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

Kind regards,  
Gerda

---

<div class="post-metadata">

**Author:** ![thaynemunson](https://community.eazybi.com/letter_avatar_proxy/v4/letter/t/bbce88/32.png) [@thaynemunson](https://community.eazybi.com/u/thaynemunson)\
**Post date:** [April 1, 2022, 7:39pm UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/5 "2022-04-01T19:39:49Z")

</div>

Thank you Gerda. The markdown formatting did the trick.  
Thayne Munson 🙂

---

<div class="post-metadata">

**Author:** ![Michael.Hermann](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/e480ec/32.png) [@Michael.Hermann](https://community.eazybi.com/u/Michael.Hermann)\
**Post date:** [April 5, 2022, 1:20pm UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/6 "2022-04-05T13:20:30Z")

</div>

Hi Gerda, I was also looking for this capability. I am trying to create a measure to make an active link with your example, but it is not working. Any advice?

Measure

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

Report

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

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [April 5, 2022, 1:58pm UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/7 "2022-04-05T13:58:41Z")

</div>

Hi @Michael.Hermann,  
I forgot to mention that my example works if the “Wiki page” dimension is used in the Rows.  
For your example, you can reference to issue property “Issue wiki page”, but it will work if you have **only one link** there:

```auto
CASE WHEN
NOT IsEmpty([Measures].[Issue Wiki page])
AND
[Measures].[Issue Wiki page] <> "(none)"
THEN
"[Wiki URL]"
||"("
||Cast([Measures].[Issue Wiki page] as string)
||")"
END

```

---

<div class="post-metadata">

**Author:** ![Michael.Hermann](https://community.eazybi.com/letter_avatar_proxy/v4/letter/m/e480ec/32.png) [@Michael.Hermann](https://community.eazybi.com/u/Michael.Hermann)\
**Post date:** [April 5, 2022, 2:01pm UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/8 "2022-04-05T14:01:14Z")

</div>

YOU…are a rockstar! Thanks Gerda!

 ![image](https://community.eazybi.com/uploads/default/original/2X/9/98cb3605654f4cfb3949e4bf878bd3292554e7f4.png)

---

<div class="post-metadata">

**Author:** ![seemore.la](https://community.eazybi.com/user_avatar/community.eazybi.com/seemore.la/32/9235_2.png) [@seemore.la](https://community.eazybi.com/u/seemore.la)\
**Post date:** [March 13, 2023, 10:45am UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/9 "2023-03-13T10:45:44Z")

</div>

he Gerda  
is there a way i can see wiki pages from specific confluence space only?

we want to measure % of the isuues linked to Analysis document  
thank you

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [March 13, 2023, 3:13pm UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/10 "2023-03-13T15:13:01Z")

</div>

Hi @seemore.la ,  
Unfortunately, [Atlassian REST API remotelink](https://developer.atlassian.com/cloud/jira/software/modules/remote-link/) doesn’t include any other information about Confluence space.  
One option is to create an [aggregate member](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-other-dimensions) in the “Wiki page” dimension with all pages in one space, but that would need a manual update to keep the members current.

best,  
Gerda

---

<div class="post-metadata">

**Author:** ![\_P3](https://community.eazybi.com/user_avatar/community.eazybi.com/_p3/32/4028_2.png) [@\_P3](https://community.eazybi.com/u/_P3)\
**Post date:** [March 23, 2023, 9:50am UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/13 "2023-03-23T09:50:02Z")

</div>

I had the problem that I only saw the markdown syntax and not the active link. Changing the format into Text, then markdown did the trick.

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [February 5, 2024, 10:22am UTC](https://community.eazybi.com/t/import-wiki-page-link-into-eazybi/4631/14 "2024-02-05T10:22:20Z")

</div>

if you use app OSLC Connector for Jira

> **[SodiusWillert OSLC Connect for Jira | Atlassian Marketplace](https://marketplace.atlassian.com/apps/1221984/sodiuswillert-oslc-connect-for-jira?hosting=datacenter&tab=overview)**
>
> Connect Jira with IBM DOORS Next, Rhapsody, ETM, EWM, Siemens Polarion ALM, and CATIA Cameo/MagicDraw

You can try this code to return the relationship text:

```auto
var newlist = new Array();
getDocument("issue/"+ issue.key + "/remotelink", {ignoreErrors: [404]}, function(result){
if (result) {
for (var i = 0; i < result.length; i++) {
let relationship = result[i].relationship;
if(relationship && relationship == "tracks requirement" ){
newlist.push(result[i].object.url.split("resources/")[1]);
}
}
issue.fields.customfield_remotelink = newlist.join(",");
}
});

```

Martins / eazyBI