Show pages with user who last modified

[Jobewan]

I am using the CQL Search Macro to inject search expressions into a Confluence page inventorying other Confluence pages.

In this use case the person who last modified the page is more important than the page Creator.

I haven't found an expression syntax that produces the desire results.

I don't have direct access to the underlying Confluence database for direct queries or script execution.

The current syntax I am using is:

creator=ABCDE and type=page order by lastModified

The output is:

PAGETITLE     SPACE
Page               SpaceName
Page               SpaceName
Page               SpaceName
. . .                  SpaceName

The desired output is:

PAGETITLE     SPACE              LAST MODIFIED BY
Page               SpaceName     Bob Doe
Page               SpaceName     Ted Doe
Page               SpaceName     Carol Doe
. . .            

Please advise.

[Gaurav]

Hello @Jobewan 

Welcome to the community!!

CQL to find the user who last modified a page is not available. The native CQL field for LastModified can be used to compare dates. In order to extend the native CQL functionality. I would suggest the usage of plugins available on the Atlassian marketplace, a list of the same is available here.

Please explore, evaluate and select the one best suited to your use case.

Kindly accept the answer if this helps.