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

[Stacy Allotta]

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. 

[Fabian Lim]

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 

[Katerina Kovriga _Stiltsoft_]

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*

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.