Suppress blank records from being displayed in Page Properties Report Macro

Adrian Speich February 5, 2018

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

1 answer

1 accepted

2 votes
Answer accepted
Andrey Khaneev _StiltSoft_
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.
February 5, 2018

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 February 8, 2018

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

Hartmut Leister April 5, 2022

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events