Skip to end of metadata
Go to start of metadata
Report output
Report elements
Column | Details |
---|
Page Title | The name of a page. |
State changed on | Date the last workflow state change occurred. |
Days ago | Time difference in days between the last workflow state change and the current date. |
Last changed by | Person who last changed the workflow state for the page. |
Version | Current (Confluence) version of the page. |
Description
This report allows you to see all pages under the 'Approved' state within the last month.
This is handy for auditors who need to check for page workflow state activity on a monthly basis.
Source code for recipe
All pages with in the 'Approved' state in the last month
<h2>All approved pages in the last month</h2>
<ac:structured-macro ac:macro-id="10430f13-f06c-4a7c-8686-2bce5c2402e4" ac:name="report-table" ac:schema-version="1">
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="199aee45-8f48-45fc-9ef8-6a2abfca819a" ac:name="content-reporter" ac:schema-version="1">
<ac:parameter ac:name="types">page</ac:parameter>
<ac:parameter ac:name="labels">product</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="06dce3d5-9d6e-4bf3-9e11-f33a9377c0c0" ac:name="date-filter" ac:schema-version="1">
<ac:parameter ac:name="minValue">-1m</ac:parameter>
<ac:parameter ac:name="beforeValue">1m</ac:parameter>
<ac:parameter ac:name="maxValue">%global:current date%</ac:parameter>
<ac:parameter ac:name="relativeTo">workflow:state>date</ac:parameter>
<ac:parameter ac:name="">workflow:state>date</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="aa2b91c0-cef0-44f4-ad6d-41660dcc56f5" ac:name="text-filter" ac:schema-version="1">
<ac:parameter ac:name="value">Approved</ac:parameter>
<ac:parameter ac:name="">workflow:state>name</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="d068ad07-cceb-48f7-bf63-5cfc091d9bc7" ac:name="text-sort" ac:schema-version="1">
<ac:parameter ac:name="">variable:Days Ago</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="da00b961-73f9-4bf7-a55d-f68f9a2925b0" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Page Title</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="11bf5953-8d26-4998-84e2-512d10cb861f" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="link">true</ac:parameter>
<ac:parameter ac:name="">content:title</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="25bb16b8-50a0-4726-a7fc-cd9759974cc6" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">State changed on</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="28f78f41-38c3-4d84-b816-29d7db3463c9" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
<ac:parameter ac:name="">workflow:state>date</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="23d9cd99-d0bf-4824-b828-a709737d1fa5" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Days ago</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="28f13e19-0a25-4c01-8c8b-0d66c4e2fc40" ac:name="report-eval" ac:schema-version="1">
<ac:parameter ac:name="default">0</ac:parameter>
<ac:parameter ac:name="format">#</ac:parameter>
<ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter>
<ac:parameter ac:name="">Days Ago</ac:parameter>
<ac:plain-text-body><![CDATA[(%global:current date>date:milliseconds% - %workflow:state>date>date:milliseconds%)/1000/60/60/24]]></ac:plain-text-body>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="f536bd09-e70e-4023-af93-830b345420c4" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Last changed by</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="528d3405-cf8e-497c-ad1a-2d55b242a176" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
<ac:parameter ac:name="link">true</ac:parameter>
<ac:parameter ac:name="">workflow:state>user</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="d9034dca-2add-4d23-99f2-49e9f45f9fef" ac:name="report-column" ac:schema-version="1">
<ac:parameter ac:name="title">Version</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="942d4d5a-5081-4567-a471-5e1d52d84c6c" ac:name="report-info" ac:schema-version="1">
<ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter>
<ac:parameter ac:name="">workflow:state>version</ac:parameter>
</ac:structured-macro>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p> </p>
<p> </p>
<ac:structured-macro ac:macro-id="f214a172-8a57-416b-9ffc-9a8729d70866" ac:name="report-empty" ac:schema-version="1">
<ac:rich-text-body>
<p>
<em>No results found.</em>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p> </p>
<p> </p>
</ac:rich-text-body>
</ac:structured-macro>