JIRA Custom Field Ordering Issue

[Santanu Roy]

Is it possible to define order of columns in JIRA, so that the same ORDER of columns appear in Confluence while using a PIVOT table ?

[Milan Chheda [INFOSYSTA]]

No. I believe, when you create a report or pivot table in Confluence, it asks for which all columns you want and therefore it can't be defined in JIRA. You can only fetch data from JIRA, but you need to select or define what all columns you want, in Confluence.

[Santanu Roy]

Suppose a field in JIRA "Approval Category" has values : QA Pass, Requirement, UAT Pass, Test Plan.

I am using the Pivot Table in Confluence and would like to use the following order "Requirement, QA Pass, UAT Pass and Test Plan". Is it possible ? I need help with the SQL Query..

Secondly, is it possible to hide a portion of the column header in SQL?