nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira table import to confluence

Smadar Sagi

I'm trying to import data from Jira using the Jira Macro

I have 2 questions:

1. is it possible to keep only the value and remove the table header?

2. how can I format the dates? the transformer Macro doesn't seem to impact it(colors are coming from transformer).

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Smadar Sagi ,

As for the Jira Issues headings, I don't think that it is possible to remove them.

What concerns the Table Transformer macro, you can modify the date format with the help of the FORMATDATE function.

Wrap your table in the Table Transformer macro body and set the required date format in the macro settings:

Mon 4-1.png

Mon 4-3.png

Now use the FORMATDATE function mentioned above:

SELECT T1.'Project',
FORMATDATE(T1.'Date') AS 'Date'
FROM T*

Mon 4-2.png

Mon 4-4.png

Hope this helps your case.

All comments

Pramodh M

Hi @Smadar Sagi

Welcome to Confluence!!

Table Header can be removed even with having data, Please refer to the second row of editor when you are working with tables

And for Color and date format, when you add the macro, there is a settings option where we can format the data

https://docs.stiltsoft.com/display/public/TFAC/How+to+use+Table+Transformer+macro

Thanks

Smadar Sagi

Thank you for the reply. This is Jira Macro not a regular table

Brant Schroeder

@Smadar Sagi Welcome to the Atlassian Community. Since you are issue macro from Jira to Confluence I would suggest reaching out to their support here: https://marketplace.atlassian.com/apps/1213392/issue-macro-from-jira-to-confluence?tab=support&hosting=server

I tried to find information about this in their documentation but it is unavailable at this time.

Katerina Kovriga {Stiltsoft}

Hi @Smadar Sagi ,

As for the Jira Issues headings, I don't think that it is possible to remove them.

What concerns the Table Transformer macro, you can modify the date format with the help of the FORMATDATE function.

Wrap your table in the Table Transformer macro body and set the required date format in the macro settings:

Mon 4-1.png

Mon 4-3.png

Now use the FORMATDATE function mentioned above:

SELECT T1.'Project',
FORMATDATE(T1.'Date') AS 'Date'
FROM T*

Mon 4-2.png

Mon 4-4.png

Hope this helps your case.

Katerina Kovriga {Stiltsoft}

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

jira

table-transformer