Issue with field sorting using Table Transformer and Pivot Table in Confluence

[Santanu Roy]

Issue with field sorting using Table Transformer and Pivot Table in Confluence.

I am using Table Transformer macro and have come-up with a sort order of a column.

Column Name: Approval Category

Values: Req, QA, BSA, UAT

However, when I am using a Pivot on top of Table Transformer, my column Sort Order is changing.

I am getting the sorting in this form (which I do NOT want).

Values: BSA, QA, Req, UAT

Is there a way to retain my sort order in Pivot, either using SQL or on JIRA?

Values: Req, QA, BSA, UAT

[Nic Brough -Adaptavist-]

Yes, although there is a bug in that you can't add one to a status that does not already have an outgoing transition.