Macro to aggregate page(s) attributes on one page

[Pawel]

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

[Kristian Klima · Accepted solution]

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

Hope it helps your case.

[Mattia _bitvoodoo ag_]

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

[Pawel]

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

[Roma Bubyakin _Wombats Corp_]

Hello @Pawel as I understand you want something following.

Based on CQL show a table with information about pages:

You can do this with our User Macro for Confluence Cloud app.

I have created a template that you can copy to your instance and modify: Aggregated pages attributes inside our app.

Best Regards,
Roman Wombats Corp