Expand wont accept table filter

[Kim Tore Holte]

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?

[Kristian Klima]

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]

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:)

[Kristian Klima]

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.

[Stiltsoft support]

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).

[Kim Tore Holte]

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:)

[Stiltsoft support]

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]

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

[Stiltsoft support]

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.