Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Expand wont accept table filter

Kim Tore Holte January 31, 2025

Hi

 

 

 

I’m trying to insert the table filter macro into the expand macro, but it just ends up outside of it. It’s very frustrating, and I know it works fine in the local version. I’m using the Cloud version of Confluence. Any suggestions for a solution?

1 answer

1 vote
Kristian Klima
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 31, 2025

Hello @Kim Tore Holte and welcome to the Community.

Some Cloud macros cannot be nested.

Having said that... 'table filter macro' is not a native Confluence macro, is it? It doesn't show up in my Confluence (Cloud, Premium)... Maybe there's a different solution for your use case.

Kim Tore Holte January 31, 2025

No, it's not a native Confluence macro. It's an app I've downloaded (Table filter, charts & spreadsheets for Confluence), but I hope that someone has a solution for this problem:)

Like Kristian Klima likes this
Kristian Klima
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 31, 2025 edited

OK... try the following:

So you have a page A with the expand macro.

  1. Create a page B.
  2. On page B, use your table filter macro.
  3. On page A, go to the expand macro and inset the Include Page macro in the expand box. 
  4. Set up the Include macro to display page B.

 

2025-01-31_13-55-57.png

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 31, 2025

Hi @Kim Tore Holte ,

Seems that you've run into a known Confluence Cloud limitation: macros with bodies can't be nested.

The workaround given by @Kristian Klima works because the Include Page (Excerpt Include or our Table Excerpt Include) is a bodiless macro.

Not sure what you mean by the "local version" where everything works: if it is Data Center, then there is no such limitation and you can nest macros directly on the page.

If you are talking about Cloud, you may have a page created in the old Cloud editor that resembles Server/Data Center. But in the new Cloud editor it is impossible (that's why for Cloud we've developed the Table Toolbox macro where you can nest several macros provided by the app).

Like 2 people like this
Kim Tore Holte January 31, 2025

OK. Thank you @Kristian Klima for your suggestion, but that won't help me in this matter. 

So, I will try the Table Toolbox macro. Thank you for your support and have a nice weekend:)

Like Kristian Klima likes this
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 31, 2025

But please note that the Table Toolbox macro contains only our macros.

For example, you wrap your source table in the Table Toolbox macro, then go inside its settings and there virtually wrap your table in the Table Filter macro for filtration, then in the Pivot Table macro for aggregation, and finally in the Chart from Table macro for visualization of the previously filtered and grouped data.

The Table Toolbox macro doesn't contain the standard Expand macro.

Kim Tore Holte January 31, 2025

OK, does that mean that the standard Expand macro will not work with the Table toolbox macro?

Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 31, 2025

The Table Toolbox is also a macro with body - you can wrap manually created and macro generated (for example, the Jira Issues macro) tables in it. It was developed to nest other macros with bodies provided by our app.

So, as you can't nest bodied macros directly on the page, you won't be able to nest the Expand and the Table Toolbox macros as well.

Like 2 people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Upcoming Confluence Events