How can I list JIRA issues in a table but change it to say something different than "X issues"?

[Matt Harlow]

I'd like to make a table in Confluence that lists quantities of JIRA issues in a project, but I would like to have it say something other than "3 issues" for example (like "3 studies" or "3 tests"). 

Am new to JIRA and Confluence and am just starting to learn JQL. Any help would be much appreciated!

[Katerina Kovriga _Stiltsoft_]

Hi @Matt Harlow ,

If your company uses our Table Filter and Charts for Confluence app, then there is a workaround using the Table Transformer macro:

SELECT T1.'Project',
T1.'Issues'->split(" ")->0 + " Your Ending" AS 'Issues'
FROM T*

The only tricky moment is that the clickable links to your Jira issues will be lost. But if necessary, you may use another Table Transformer macro at the top of the first one and recreate the links following this example.

[Matt Harlow]

Thank you! Is that syntax all SQL? Yet again, beginner here. Just trying to dissect and understand it. May warrant diving further if it is SQL.

[Katerina Kovriga _Stiltsoft_]

Yes, you are right - the Table Transformer macro is based on the AlaSQL library.

[Katerina Kovriga _Stiltsoft_]

Hi there,

As this Community question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view&edit mode. The Table Spreadsheet macro is available for Cloud and Server/Data Center.

[Brant Schroeder]

@Matt Harlow Welcome to the Atlassian community.  

It says issues because that is what all items in Jira are called.  You can have different issue types but there is no way for you to change this in the Macro.  You can however easily add a title above the Jira issue macro that explains what types of issues your end-user is looking at.