Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,294,826
Community Members
 
Community Events
165
Community Groups

jira issue filter macro - display filter item text for the filter (PRIORITY) instead of the icon

Hello, we are using the Jira Issue Filter macro (table report) on a Confluence page and when we select the filter "PRIORITY" for a column in the report, it displays the icon for "PRIORITY", but it would be much more helpful to spell out the text (MEDIUM, HIGH, ...) rather than just show the icon.  Is there a work around for this?  Thanks in advance for any assistance. 

1 answer

1 vote
Fabian Lim Community Leader May 05, 2022

Hi @Stacy Allotta

Welcome to the community!

out of the box this is not possible. I believe a plugin such as custom table filters allows you to do this.

Link: https://marketplace.atlassian.com/apps/27447/table-filter-and-charts-for-confluence?tab=overview&hosting=cloud

 

Regards 

Hi @Stacy Allotta ,

As @Fabian Lim has kindly mentioned, our Table Filter and Charts for Confluence app and its Table Transformer macro will do the trick.

List all the statuses you have in the SQL query and choose what names you want to show:

SELECT *,
CASE WHEN T1.'P' LIKE "Trivial"
THEN "Trivial"
WHEN T1.'P' LIKE "Major"
THEN "Major"
END
AS 'Priority'
FROM T*

Mon 4-1.png

Later you may use the Table Filter macro on top of the Table Transformer macro to filter your issues on the fly and hide the "P" column that is of no use anymore.

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

833 views 10 23
Read article

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