Suppress blank records from being displayed in Page Properties Report Macro

[Adrian Speich]

Hi,

I have a Page Properties Macro on various pages with the same table on each page.

On some pages the table contains data, on others it does not. The pages are linked to a Page Properties Report which returns a record where the table contains data, and just the page title on an otherwise blank row where it does not.

Is it possible to only return records where the Page Properties Report table is populated, and not return a row where the Page Properties Report table is blank?

Thanks

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hi Adrian,

It is only possible to filter out this rows with Table Filter macro: add a dropdown reversed filter with -Empty- value for the column and hide the filtration pane if needed.

[Adrian Speich]

Thanks. It's a not a problem which justifies purchasing a plugin at this stage but good to know.

[Hartmut Leister]

very nice, since we're already using this plugin, that helps us.

There's one caveat, however:

Since filtering is only done after aggregation of the Page Properties Report, you might end up with multiple (potentially) empty Page Property Report Pages if the Page Propery Report contains more than 30 pages (before applying the table filter).

You can use a workaround to increase "Number of items to display" to get a single page Page Property Report, which can then be filtered using the Table Filter macro.

see https://confluence.atlassian.com/doc/page-properties-report-macro-186089616.html