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; } } }

Can you combine multiple fields into one cell of Jira table?

Laurie Huth

I am building a table in Confluence (using the 'Jira Issue/Filter' macro). I selected the data I want to display in my table, i.e. Key, Due Date, Summary, External Document, and Internal Document.

Can I combine some of this content into the same column of the table? Specifically, I want the results for External Documents and Internal Documents to show in just one column and not have two separate columns.

In other words...So for each row, Key, Due Date, and Summary results would show in the first three separate columns, but the fourth column would include both External and Internal documents combined in one cell.

Accepted answers

Ste Wright

Hi @Laurie Huth

Not natively, using that macro.

You could...

Create an actual Confluence table
Create multiple Jira Issue/Filter macros - across the relevant columns
Set each to show just one field from the search, whichever field is relevant to each column

...but it's not an ideal option.

The alternative is to find an App with more powerful table editing/layout options - such as Table Filter and Charts for Confluence - and test if this allows you to do as needed!

Ste

All comments

Ste Wright

Hi @Laurie Huth

Not natively, using that macro.

You could...

Create an actual Confluence table
Create multiple Jira Issue/Filter macros - across the relevant columns
Set each to show just one field from the search, whichever field is relevant to each column

...but it's not an ideal option.

The alternative is to find an App with more powerful table editing/layout options - such as Table Filter and Charts for Confluence - and test if this allows you to do as needed!

Ste

Katerina Kovriga {Stiltsoft}

Hi @Laurie Huth ,

Our Table Filter and Charts for Confluence app that was kindly mentioned by @Ste Wright may indeed help your case.

Wrap your Jira Issues macro in the Table Transformer macro:

Mon 3-1.png

On the screenshot I use a manually created table, but this is only for a more clear example - the Jira Issues macro' output is fully supported by the app.

Then use a simple SQL query where you list what columns you need to show as they are ("Project" for my example) and merge the required columns ("Column 1" and "Column 2" for the case):

SELECT 'Project',
FORMATWIKI(SUM('Column 1' + "\n" + 'Column 2')) AS 'Column 3'
FROM T*
GROUP BY 'Project'

And here is the result:

Mon 3-2.png

Hope this helps your case.

Laurie Huth

OMG. You two are the best!!!! It works. I am so happy you found a solution. Thank you, thank you!!!

One more question though... Going back to Katerina's example, if Column 1 and Column 2 have data in them, it merges beautifully (using the SQL that was provided).

FORMATWIKI(SUM('Column 1' + "\n" + 'Column 2')) AS 'Column 3'

However, if Column 1 or Column 2 is blank, then the merge is completely blank as well. How do I at least show the partial data? For example, what if Column 1 has info, but Column 2 doesn't? I still want the new, Column 3 to show the info from Column 1?

Katerina Kovriga {Stiltsoft}

Hi @Laurie Huth ,

Try to modify your SQL query in the following way:

Tue 4-2.png

SELECT 'Project',
FORMATWIKI(SUM('Column 1' + "\n" + 'Column 2')) AS 'Column 3'
FROM (
SELECT *,
CASE
WHEN 'Column 1' IS NULL
THEN "No External Documents"
ELSE 'Column 1'
END
AS 'Column 1',
CASE
WHEN 'Column 2' IS NULL
THEN "No Internal Documents"
ELSE 'Column 2'
END
AS 'Column 2'
FROM T*)
GROUP BY 'Project'

Tue 4-1.png

Here we fill the blank cells and then merge the two columns. Hope it works for you.

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

confluence

cloud

confluence-cloud