hi ,
Is it possible to import linked confluence page on a ticket as ‘Wiki Page’ and be displayed on the reports?
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) 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:
- Using it as property:
best,
Gerda // support@eazyBI.com
2 Likes
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 
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
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
Hi @seemore.la ,
Unfortunately, Atlassian REST API remotelink doesn’t include any other information about Confluence space.
One option is to create an aggregate member 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
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.
if you use app OSLC Connector for Jira
You can try this code to return the relationship text:
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