I would like to display the name of the Priority as well as the the icon when I use the Issues Filter to display JIRA issues in Confluence. Is this possible?
Hi Maureen,
Unfortunately, the priority column only shows the icon. You can use the following plugin that can help: https://marketplace.atlassian.com/apps/27447/table-filter-and-charts-for-confluence?hosting=cloud&tab=overview
Regards
Hi @Maureen McManus ,
As @Fabian Lim has mentioned, our Table Filter and Charts for Confluence app and its Table Transformer macro can really do the trick: wrap your Jira Issues macro into our Transformer and list all the possible statuses and their colors via the custom SQL query.
Here is an example for our local Jira instance:
SELECT *,CASEWHEN 'P' LIKE "Major"THEN FORMATWIKI("{status:colour=Red|title=Major}")WHEN 'P' LIKE "Minor"THEN FORMATWIKI("{status:colour=Blue|title=Minor}")WHEN 'P' LIKE "Critical"THEN FORMATWIKI("{status:colour=Black|title=Critical}")WHEN 'P' LIKE "Trivial"THEN FORMATWIKI("{status:colour=Green|title=Trivial}")ELSE FORMATWIKI("{status:colour=Grey|title=Blocker}")END AS 'Priority'FROM T1
The "P" column can be hidden if necessary (not listed in the Table Transformer macro or hidden via the Table Filter macro if you further proceed to filter your Jira table).
Hope this may help your case.
Hi there,
As this 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 and edit mode.
The Table Spreadsheet macro is available for Cloud and Server/Data Center.
It looks like you're new here. Sign in or register to get started.
