Import wiki page link into eazybi

hi ,

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

image

Hi @Rajatgupta,

eazyBI does not have default support for Confluence link import into eazyBI. But you can use JavaScript calculated customfield (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++) {
      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
  • Using it as property:
    Wiki-properties.png

best,
Gerda // support@eazyBI.com

1 Like

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

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

For “Wiki pages” it could look like this:

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

In the report:

Kind regards,
Gerda

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

1 Like

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

Report

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:

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

YOU…are a rockstar! Thanks Gerda!

1 Like