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

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

Accepted answers

Andrey Khaneev _StiltSoft_

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.

All comments

Andrey Khaneev _StiltSoft_

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_zehkfc

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