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

Macro to aggregate page(s) attributes on one page

Pawel_a57ccj

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

Accepted answers

Kristian Klima_gtcuat

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...

All comments

Pawel_a57ccj

Sounds as a solution however it require to modify each of existing page to create the template with relevant attributes i want to fetch on aggregate page.

Assuming that each page has unique and only one attribute i want to extract the following only:

Source page title
Author
Updated
Status (predefined)
- On Hold
- In Progress
- In Review
- Done

Using page metadata, search for attribute X and fetch value(in case of status), show in the table such attribute in relevant column.

I have planty of pages/articles that i would need to manually update per the template as per the manual above.

Any other tips?

Thanks for the help

Pawel

Kristian Klima_gtcuat

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...

Stiltsoft support

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