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

How do I list all pages with titles and, last modified by and updated date based on labels for a specific time period

Aby12345

I have a couple of individual component status pages under a parent page. The sub pages are updated regularly with current status. I want to list all the sub pages, their last modified by user, last modified date, and If these pages were updated in the last 7 days.

This can be done easily using the SQL macro I guess.

My requirements are to list this in tabular format and Is this do-able without using the SQL macro and tweaking the recently updated macro or page properties etc?

Accepted answers

Stephen Deutsch

Here's the user macro:

## @noparams
#set ( $descendantPages = $pageManager.getDescendents($content) )
#set ( $compareDate = $action.dateFormatter.getCalendar() )
$compareDate.setTime($content.getCurrentDate())
$compareDate.add(6, -7)
&lt;table&gt;
  &lt;tr&gt;
    &lt;th&gt;Page&lt;/th&gt;
    &lt;th&gt;Last Modifier&lt;/th&gt;
    &lt;th&gt;Modified Date&lt;/th&gt;
    &lt;th&gt;Modified &lt; 7d?&lt;/th&gt;
  &lt;/tr&gt;
  #foreach ( $page in $descendantPages )
  &lt;tr&gt;
    &lt;td&gt;&lt;a href="${req.contextPath}$page.urlPath"&gt; $page.title &lt;/a&gt;&lt;/td&gt;
    &lt;td&gt; $page.lastModifier.name &lt;/td&gt;
    &lt;td&gt; $action.dateFormatter.format($page.lastModificationDate) &lt;/td&gt;
    &lt;td&gt;
       #set ($pageDate = $action.dateFormatter.getCalendar())
       $pageDate.setTime($page.getLastModificationDate())
      #if ( $pageDate.before($compareDate) )
        &lt;span class="aui-lozenge aui-lozenge-error"&gt;NO&lt;/span&gt;
      #else
        &lt;span class="aui-lozenge aui-lozenge-success"&gt;YES&lt;/span&gt;
      #end
    &lt;/td&gt;
  &lt;/tr&gt;
  #end
&lt;/table&gt;

All comments

Stephen Deutsch

This is certainly possible using a user macro, but your requirements are not very clear. In your title, you say "based on labels" but in your description, you say "pages under a parent page". How are you supposed to determine which pages are in the list?

Doug Swartz

The Confluence Reporting add-on from Service Rocket.can do all this.

I don't know of a native Confluence way to do this.

Aby12345

Hi Stephen, Sorry my bad. Either way if it is possible, works for me. I have used the recently updated macro with labels on each sub page to aggregate information as of now. But this is restricted only to the information that the macro can retrieve. In an SQL query I am assuming I would be able to pass the Parent PageID to get all the sub pages. The recently updated macro only fetches for a space. Please let me know your feedback on how to do this using a User macro.

Stephen Deutsch

Here's the user macro:

## @noparams
#set ( $descendantPages = $pageManager.getDescendents($content) )
#set ( $compareDate = $action.dateFormatter.getCalendar() )
$compareDate.setTime($content.getCurrentDate())
$compareDate.add(6, -7)
&lt;table&gt;
  &lt;tr&gt;
    &lt;th&gt;Page&lt;/th&gt;
    &lt;th&gt;Last Modifier&lt;/th&gt;
    &lt;th&gt;Modified Date&lt;/th&gt;
    &lt;th&gt;Modified &lt; 7d?&lt;/th&gt;
  &lt;/tr&gt;
  #foreach ( $page in $descendantPages )
  &lt;tr&gt;
    &lt;td&gt;&lt;a href="${req.contextPath}$page.urlPath"&gt; $page.title &lt;/a&gt;&lt;/td&gt;
    &lt;td&gt; $page.lastModifier.name &lt;/td&gt;
    &lt;td&gt; $action.dateFormatter.format($page.lastModificationDate) &lt;/td&gt;
    &lt;td&gt;
       #set ($pageDate = $action.dateFormatter.getCalendar())
       $pageDate.setTime($page.getLastModificationDate())
      #if ( $pageDate.before($compareDate) )
        &lt;span class="aui-lozenge aui-lozenge-error"&gt;NO&lt;/span&gt;
      #else
        &lt;span class="aui-lozenge aui-lozenge-success"&gt;YES&lt;/span&gt;
      #end
    &lt;/td&gt;
  &lt;/tr&gt;
  #end
&lt;/table&gt;

Aby12345

Brilliant. Thanks a lot Stephen, This is exactly what I needed. Please pardon the delay in answering as I dont have rights to directly create a user macro. Please do refer documentation where I can learn more about confluence/JIRA objects as used in the macro.

Stephen Deutsch

Hi Abhilash, glad I could help you out. Here is one resource for the Confluence objects used in user macros: https://developer.atlassian.com/confdev/development-resources/confluence-architecture/confluence-internals/velocity-template-overview/confluence-objects-accessible-from-velocity Other than that, it's a lot of Google searching and browsing here on Atlassian Answers. I also have a few User Macros on my bitbucket account: https://bitbucket.org/stephendeutsch/confluence-user-macros

Jim Cork

Is there an easy way to modify the above to have an 'Exclude Labels' parameter which will hide any child pages that have the 'meeting-notes' label?

karen.wright40

Sorry to revive this, great bit of code and really helpful however is there a way to output childpages only and not child and grandchild pages as it currently does with:

#set ( $descendantPages = $pageManager.getDescendents($content) )

Stephen Deutsch

You should be able to replace it with the following:

#set ( $descendantPages = $content.getChildren() )

I didn't get a chance to test it, but I think that will work.

al fredmi

Hi Stephen. This looks like a great idea. Can I create the user macro in the new confluence version today?
Also, is it possible to have a choice inside the macro when chosen, to pick which would be the 'parent page'? then I dont have to modify the target, I could run this from a different page. Or must I always add this macro to the page that I want to check its children?

Thank you very much!

Dale Westrate

This sounds like just what I'm looking for (a list of all Space pages along with their created & modified dates), but I can't get it to work; all I get is the following:

<table> <tr> <th>Page</th> <th>Last Modifier</th> <th>Modified Date</th> <th>Modified < 7d?</th> </tr> </table>

What am I doing wrong?

Cindy_8r0m4m

Also running into a similar issue! Any insight?

Evanna McMahon

I have also this error. Did anyone find out how to resolve this ?

jiratest

Me too. going through the same issue.

actually I wanted to find all the edits or creation in pages during certain frame of time. So unable to do that. Please suggest some ways to do that.

Jim Cork

Hi Stephen,

Thanks for all your help with this. Could you by any chance let me know of a way to ONLY show the list of pages that HAVE NOT been modified in the last X period, and NOT showing any pages that HAVE been modified in the last X period.

Regards,

Jim Cork

Elina Wegner

Hello,

I am trying to get something similar but rather need the creation date of each child page.

I tried substituting

$action.dateFormatter.formatGivenString("yyyy-MM-dd", $content.getCreationDate())

for

$action.dateFormatter.format($page.lastModificationDate)

but because all of the child pages were initiated via a template they all have the same date...

Can you help with a marco that will provide me with a table listing all of the pages contained within a certain dashboard, who they were created by and the actual creation date knowing that the pages were created using a template?

Thank you all so much!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence