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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.