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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.