Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying table field from Jira in confluence

Zeeshan Hasnain December 4, 2022

My JQL output contains a table as one of the fields called Milestones i.e the Milestones field contains a nested table. The JQL output looks like this in Jira 

Key                  | Milestones

ABC-123          | Num | Milestone | Date              | Update By | Updated On 

                        | 10     | Review      | 01/02/2023   | xyz             |  25/12/2022 

                        | 20    | Exit            | 01/30/2023   | xyz             |  25/12/2022 

 

ABC-456          | Num | Milestone | Date              | Update By | Updated On 

                        | 10     | Initiate     | 01/02/2023   | abcdefg     |  25/12/2022 

                        | 30     | Sign-off    | 01/02/2023  | opqrst        |  25/12/2022 

 

When I use Jira Chart/Filter macro in Confluence the output merges all of the Rows and Columns into a single cell. The output on confluence page looks like this. 

Key                  | Milestones

ABC-123          | 10 Review 01/02/2023 xyz 25/12/2022 20 Exit 01/30/2023 xyz 25/12/2022 

ABC-456          | 10 Initiate 01/02/2023 abcdefg 25/12/2022 30 Sign-off 01/02/2023 opqrst                              25/12/2022 

 

The | represents the column border. I would like know if this is by design in confluence or is it wrongly configured? I need those milestones date to appear in separate rows. Your help is highly appreciated. 

2 answers

2 votes
Katerina Rudkovskaya _Stiltsoft_
Atlassian Partner
December 5, 2022

Hi @Zeeshan Hasnain,
 

There is indeed some trouble with custom fields coming from the Jira Issues macro: tabular data, list of statuses, etc. are displayed as plain one-row text in Confluence.

Zeeshan Hasnain December 5, 2022

Yes and that makes using things like Table Transformer even harder because the data becomes completely unstructured once brought into confluence. 

Katerina Rudkovskaya _Stiltsoft_
Atlassian Partner
December 6, 2022

@Zeeshan Hasnain, in case of any questions or difficulties working with Table Transformer, please feel free to contact our support team

Katerina Rudkovskaya _Stiltsoft_
Atlassian Partner
December 6, 2022

@Zeeshan Hasnain unfortunately, it's a known issue with low priority. You may try to gather more interest to the problem: CONFSERVER-55482

0 votes
Dorian Schauwers December 5, 2022

Hello,

 

Have you tried to add the needed columns in the display options when using the JIRA macro in Confluence?

image_2022-12-05_100446019.png

 

image_2022-12-05_100647747.png

 

If this does not help you to solve your problem, could you please provide some screenshots?

 

Thank you,

 

Dorian

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events