Jira issue macro priority name

[Hanief Mumtazul Anwar]

Hi, is there a possible way to show priority names in table column of Jira issue macro, instead of just showing the icon?

[Katerina Kovriga {Stiltsoft}]

Hi @Hanief Mumtazul Anwar ,

There is such workaround with the help of the Table Filter and Charts for Confluence app and its Table Transformer macro.

Wrap your Jira Issues into the Table Transformer macro body and use a custom SQL preset to create a new column with conditional statuses:

SELECT *,
CASE
WHEN T1.'P' LIKE "Major"
THEN FORMATWIKI("{status:colour=Red|title=High}")
ELSE FORMATWIKI("{status:colour=Green|title=Low}")
END AS 'Priority New'
FROM T1

Here I used only one priority type cause it's an example but you should list all of them and choose any lozenge colors and names as you need.

If you don't need the old 'P' column and/or want to change the columns' order, just list the required column names after the SELECT instead of the *: SELECT T1.'Key', T1.'Created', etc.

Hope this helps your case.