Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can I display the Priority name/description in the Issues Filter results in Confluence

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?

1 answer

1 vote
Fabian Lim Community Leader Dec 11, 2021

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 *,
CASE
WHEN '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

Mon 3-1.png

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.

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you