Macro to aggregate page(s) attributes on one page

Pawel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 7, 2025

Hello

Under my project i want to fetch some attributes per page as page owner/set status/page name or link whatever it tracks(still those are attributes). Then i want to have an aggregate page where i can see all of those pages with defined attributes and its latest statuses consolidated in table like format.

 

How i could do it using with use of macros preferably or please point the marketplace.

 

Thanks

Pawel

4 answers

1 vote
Stiltsoft support
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 7, 2025

Hi @Pawel ,

We develop the Table Filter, Charts & Spreadsheets for Confluence app (maybe you already have it in your instance), so maybe such workaround will suit your case:

  • Create a template for new pages with our Table Excerpt macro (for example, with an empty one-cell table to mention in its header that it is required for further attributes collection)
  • Each new page is created from this template
  • On the master page you place the Table Excerpt Include macro where you collect all these one-cell tables and choose to grab the following metadata:
    • Source page title
    • Parent page title
    • Space title
    • Space key
    • Labels
    • Source page excerpt (abstract)
    • Author
    • Last modifier
    • Created
    • Updated
    • Page version
    • Page ID
  • The chosen metadata is generated automatically and placed in separate columns
  • Then you may wrap your Table Excerpt Include macro in the Table Filter macro for further filtration. Besides, you'll be able to hide the unwanted column coming from those one-cell tables that we've used earlier
  • As a result, you'll get a dynamically changing table with metadata that can be filtered and aggregated

Hope it helps your case.

0 votes
Mattia _bitvoodoo ag_
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 7, 2025

Hello @Pawel

The options to do this without 3rd party apps have already been suggested.

With our Content & Usage Report in the Viewtracker app, you can view the page attributes you have listed and more.

Kind regards,
Mattia

0 votes
Kristian Klima
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 7, 2025

Hi @Pawel and welcome to the Community.

Depending on what attributes of your pages (and what you wanna do with them)...

  • Confluence Databases - if your first column is a page link (more on this here although it might be slightly out of date...), then other columns can be set up to list attributes of those pages - last updated, when, by whom, owner, page status, version, label, excerpts...
  • Content manager in Confluence can display some attributes
  • Check Pages Manager and Panorama
    One is free, one is basically free, they display slightly different set of attributes, offer forms of filtering and bulk-changes...
0 votes
Pawel
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 7, 2025

i dont want to use page properties hence it additional part to fill in while i already have those attributes available per each page.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events