How to perform calculations in confluence using Jira issues count?

Manupriya S

Hi,

In confluence, I want to create a table which performs certain calculations, such as: adding the two different Jira issues count. 

suppose:

I have total open issues count = 50 issues {got using the Jira Macro}

Another value that i have is, total closed = 40 issues {got using the Jira Macro}

Now i would like to perform sum on the above two Jira issues macros such that my result is:

TOTAL ISSUES = 50(Total open) +40(total closed)   

Total issues= 90

So i need to build-in something dynamic - a table which fetches the values from the Jira (using a query to look for particular issues result) and perform calculations on it.

Please help out. 

Happy to use coding and gadgets/plugins as well if possible to perform this.

Thank You

DPKJ

@Manupriya S

You have four possibilities here,

1. Statistics gadget,
2. Using User Defined Macro
3. HTML Macro and
4. Using plugin at back-end.

Statistics gadget,

• Go to Jira and configure statics gadget (as things you want to see on confluence)
• You can find this on dashboard widget sections
• Now in confluence admin locate `External Gadget`
• Go to this page, and then to Gadget Feed tab
• Add your Jira base url here
• Now go to any confluence page in edit mode
• Go Other macro,  and search for `statistics`.
• Add this to page.
• More here - https://community.atlassian.com/t5/Confluence-questions/How-to-insert-the-JIRA-quot-Issue-Statistics-quot-chart-in-a/qaq-p/145074

This will have some short comings, like you not see added results.

User Defined Macro/HTML Macro

• You need to call Jira rest api and get appropriate results and display them as you like
• This will require adding Javascript to your macro content,
• Run the following REST query on the Confluence server to obtain JIRA's UUID (universal unique identifier):
  

  <Confluence URL>/rest/jiraanywhere/1.0/servers

  Which returns:

  [
    {
      id: "<UUID>",
      name: "JIRA",
      selected: true,
      url: "<JIRA URL>"
    }
  ]

• Copy the "id" value, this is the UUID.
• Plug that value from #2 into a standard ajax call using jQuery:
  

  jQuery.ajax({
    type: "GET",
    url: "<Confluence URL>/plugins/servlet/applinks/proxy?appId=<UUID>&path=<JIRA URL>/rest/api/latest/search/jql=<YOUR_JQL>",
    dataType: "json",
    async: false,
    success: function( data ) {
        //process data and render it in html tags
    }
  });

 

Back-end Plugin

• In this approach you can create Macro plugin
• call jira rest api using App-Links
• and render results
• This will require knowledge of plugin development and Java.
• Useful links
  • Macro Module - https://developer.atlassian.com/server/confluence/macro-module/