Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,059
Community Members
 
Community Events
165
Community Groups

Suppress blank records from being displayed in Page Properties Report Macro

Edited

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

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.

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

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
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

142 views 1 3
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you