Include last modified date and user in Page Properties Report

[MarkC]

Is there a way, or a workaround, that will allow me to include the following two items in the Page Properties Report macro?

• Last Date Modified - The last date when the page was modified
• Last User to Modify - The name of the last user who modified the content

I realize they could manually type it into the page properties, but that just isn't feasible when the information is already on the page. Can this be pulled in?

[MarkC · Accepted solution]

Well, I just went ahead and created my own user macros to solve the problem. For anyone interested, the two macros below do nothing more than display the date and the name of the user who last modified the page on which the macro has been placed.

Last Date Modified

$action.dateFormatter.formatDateTime($content.getLastModificationDate())

Last User Modified

#usernameLink($content.getLastModifierName())

[MarkC]

Unfortunately, the above didn't work quite as planned. The macro is placed in the page properties macro, but when it is pulled into another page using the Page Properties Report macro, my macro above is pulling in that page's last mod user and date rather than the page on which it was placed.

Any ideas?

[MarkC]

It's been a long time, but after an update to Confluence 5.5, the above now works.

[Linh Nguyen]

How do I put/apply those your macros into my confluence page?

[Katie Milham]

Thank you.  I'd love to know how to implement this as well...

[Chad Barnes]

Linh and Katie,

You have to write/create these macros via the macro editor in the system administrator UI.

https://confluence.atlassian.com/doc/writing-user-macros-4485.html

[Chad Barnes]

For instance:

## Macro title: My Macro
## Macro has a body: N
## Body processing: Selected body processing option
## Output: Selected output option
##
## Developed by: My Name
## Date created: dd/mm/yyyy
## Installed by: My Name
## This is an example macro
## @noparams
#usernameLink($content.getLastModifierName())

[Bonnie Gier]

@chad barnes Could you share the exact macro info for the last modified date?  I tried using the user macro, but was unsuccessful.

[Chad Barnes]

• Visibility: Visible to all
• Categories: Confluence content
• Body processing: No macro body
• Template: (use the code above)

Really, the only two important things are the "No macro body" and the code I provided.

Also, realize that after saving the macro it will take a little time (few seconds) for it to appear in the macro browser. And, you may have to refresh the whole page and re-enter the page editor to get the updated macro browser.

[Chad Barnes]

2016-11-16_6-36-41.png

[Agatha Lai]

Does anyone know if there is a way to do this in Confluence Cloud?

[Sergio Ruiz]

Hi Agatha... If you have it available try inserting a Report Info macro and enter the following in the key field: content:modification date.

In the format field you can play with the way that date is displayed.

I hope it works for you!

[NancyB455]

Exactly what I was looking for.  Can't wait to try it!

[Allen Koronkowski]

Thanks for posting this--just what I needed!

[Sam Smith]

Can anyone help me find the 'Report Info' macro, I cannot see this as a macro to add.

[Veve]

Does someone have a solution for the new cloud editing too? I suppose the Report Info macro was obliterated.

[Rylan Maschak]

@Veve There is a thread for Confluence Cloud here that references an open idea asking for support.

[Rao B]

Hello, 

I tried with following code, but it will display current users last modified date. 

$action.dateFormatter.formatDateTime($content.getLastModificationDate())

Could you please some one help, how to display list of users last modified date.

Thanks in advance

[Pankaj Rana]

For our Confluence instance (7.19) below user macro stopped working which was working on earlier datacenter version 7.13. Any advise on how to fix this?

Last User Modified

#usernameLink($content.getLastModifierName())

[Daniel Kühner]

Atlassian restricted the variables in the User Macro Velocity context, see here https://developer.atlassian.com/server/confluence/confluence-objects-accessible-from-velocity/#user-macro-velocity-context

You have to add the following variables:

• action
• htmlUtil
• permissionHelper
• req

-Dmacro.required.velocity.context.keys=action,htmlUtil,permissionHelper,req

You can find out this by yourself by searching the Confluence source code for the Velocity macro #usernameLink and watch out for the used variables:

macros-deprecated.vm

#macro (usernameLink $username) [...]