Wrap your Jira Issues into the Table Transformer macro body and use a custom SQL preset to create a new column with conditional statuses:
WHEN T1.'P' LIKE "Major"
END AS 'Priority New'
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.
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
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