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

Table Filter Macro using Variable as Input

Emily Berg_alwhtk

I have several pages that I need to create that reference the same table excerpt. Within the header of the Confluence page I would like to include the inputs for filter the table (so I don't have to edit the macro for each page). Is there way to reference a variable within a Filter Table macro? In this example, I would like to filter the table based on "Unit #" column. And my input is "Alpha-2".

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Emily Berg ,

If I got your case right, you reuse the source table and wrap every Table Excerpt Include macro into the Table Filter macro to filter by different columns and values (so you'll get a kind of a dashboard).

Unfortunately, we don't have any automatic rules to assign filters/values to the Table Filter macro based on additional tables or smth similar.

All comments

Katerina Kovriga {Stiltsoft}

Hi @Emily Berg ,

Unfortunately, we don't have any automatic rules to assign filters/values to the Table Filter macro based on additional tables or smth similar.

Emily Berg_alwhtk

Hi @Katerina Kovriga _Stiltsoft_ ,

Okay fair enough. How about if I wrap the Table Excerpt into a Table Transformer Macro and "filter" the table that way - could I use a page variable to reference in the SQL query to extract a line(s) of interest?

Emily

Katerina Kovriga {Stiltsoft}

Hi @Emily Berg ,

The Table Transformer macro can use a page variable in its SQL query:

image (1).png

SELECT T1.* FROM T1
WHERE T1.'Name' = (SELECT T2.'Variable' FROM T2)

The big source table can be reused and inserted via the Table Excerpt Include macro. But you'll still need to wrap your reused table into the Table Transformer and create a mini-table with a different value for all your pages.

It seems that it is not faster than manually filtering you table with the Table Filter macro.

Have I got your case right? You need to have different values for every page?

If you want to show the same filtered table on all of your pages, then you'll need to set your filter once and wrap both your source table and the Table Filter macro on top of it into the Table Excerpt macro.

Emily Berg_alwhtk

Thank you @Katerina Kovriga _Stiltsoft_ ,

Yes, this is what I was going for, but I was hoping to be able to reference a variable outside of the table transformer macro - like maybe within the page's properties macro? I am trying to prevent an error when typing text and then having to select the proper filter (duplicate entries).

Emily

Welcome!

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

Quick Links

Find more posts tagged with

confluence

server

confluence-server

filter

table-filter