Creating report in confluence with inputs from Jira projects

[Neeti Dargan]

I need to create a weekly project status confluence report wherein there will be approx 15-20 projects tobe included.

All these projects will be created in Jira as well  which will used for test execution purpose.

Now in order to reduce the manual effort of the team, is it possible  to get all the details( project start date/end date, total test cases, defects etc) from each of the jira project and put them in the confluence report

Something like below?

Project Name	Start Date	End date	Total test cases	Passed	Failed	Defects
DM1234	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project
DM5678	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project	Get from Jira Project

[Stiltsoft support]

Hi @Neeti Dargan ,

Seems that there can be also several workarounds using 3rd party apps.

Our company develops the Table Filter, Charts & Spreadsheets for Confluence app that supports the Jira Issues macro.

So, you may firstly insert the Jira macro on your Confluence page and use a JQL to display information related to your project(s). You can use different conditions but as a result you'll get a tabular list of related issues with dates, statuses, and so on.

Then you may use our macros (Pivot Table, Table Transformer) to aggregate (count) your issues by statuses (dates, overall number, etc.). Furthermore, you'll be able to visualize your data with the help of the Chart from Table macro.

As you haven't specified your hosting, for Data Center you'll be able to nest macros directly, for Cloud - via the Table Toolbox macro.

If you are not familiar with the app, please book a live demo from the team - we'll show you several use cases based on Jira macros. 

[Maria Del Rosario Gonzalez]

Hi @Neeti Dargan - I have been using the Table Filter solution mentioned above in Cloud environment with much success.  I would highly recommend you look into this to create your reports!

[Stiltsoft support]

@Maria Del Rosario Gonzalez ,

Thank you for the positive feedback! I'll pass it to the team.

[Radek Dostál]

Not easily I reckon, if you do some googling around this you'll find some discussions like these:
 # https://community.atlassian.com/t5/Confluence-questions/User-Macro-fails-with-Ajax-call-to-JIRA/qaq-p/1167186

 # https://community.developer.atlassian.com/t/post-requests-to-applinks-proxy-fail/32516

I don't know what "Get from Jira Project" means really, but I will just assume you know how to get it, either via some jql query or otherwise.

The only idea I see here is that you could create a user macro that will fetch the data from Jira, you process the response, generate the table, render that table.

This would rely on application link between Confluence and Jira and using some form of applink proxy (similar to those posts above) so that the calls to Jira are authenticated by the user.

Without app links, you'd have to hardcode some auth credentials into the user macro, which would be entirely unsafe and negligent.

I can't give you any example of a proof of concept as I've never done this, but there should be a way to make this work (though with a lot of struggle).

I suspect it will require a heavy dose of javascript, which I don't know whether the user macro will even allow; though it should allow jQuery so I assume it's fine with JS.

I'm reasonably sure that a user macro is too minimalistic for this type of thing and it would be entirely too complex to fit a single little text box.

It probably will be pretty performance unfriendly also. A loaded page should be cached and okay, but loading several of such macros might start to be a concern depending on the complexity.

Long story short, this would be better as a plugin which will supply a macro for this, with actual backend support to do all the calls and reformats and so on, plus it has better access to Application Links API.

I think a user macro might be capable of doing it, but it's simply not a good fit. Also there is still a question whether a user macro will support script tags, or that the app link proxy endpoints work, etc.