How to remove the hyperlinks from Jira Macros on Confluence?

Question

I have two Jira macros on my Confluence page - one as Jira Issues and the other as the Agile Wallboard gadget. I want to share this page with our users, so that they can see what we are working on, but, I want to remove the links so that they cannot click on the issues and access our backlog/Kanban Board. How to do this? Help is really appreciated!

Katerina Kovriga {Stiltsoft} · Answer

Our macros support the dynamic Confluence macros, but they should be in a tabular form (for example, Jira Issues, Page Properties Report, Content Report Table).

The Agile Wallboard gadget looks like a Kanban board or smth - it's not a table. The Table Transformer macro will mess up all the formatting.

If you have our app, you may try to build pivot (aggregated) tables using our Pivot Table macro and group issues by statuses, assignees, etc. using the Jira Issues macro. It may be a kind of workaround to replace the gadget.

Grace Dowling · Answer

.

Katerina Kovriga {Stiltsoft} · Answer

Hi @Grace Dowling ,

We can suggest the following workaround using our app - Table Filter and Charts for Confluence.

The add-on provides the Table Transformer macro that is often used for table calculations, conditional formatting and cells' adjustment. The latter could be a workaround for your case: wrap the Jira Issues macro into the Table Transformer macro.

Then set the required width for the columns with links ("Key" and "Summary"):

SELECT *,
FORMATWIKI("{cell:width=150px}" + 'Key'+ "{cell}") AS 'Key',
FORMATWIKI("{cell:width=300px}" + 'Summary'+ "{cell}") AS 'Summary'
FROM T*

The FORMATWIKI function transformed our links into plain text and the custom column width allows you to make the table easy to read (for example, if we have long summaries).

Here is the screenshot of how the Jira Issues table looks when the page is published:

Hope this may help your case.