List the statuses of pages in a space

Scenario

With this recipe, you will create a table that shows the status of controlled documents (Comala Document workflows). 

Result

Recipe

Apps

Reporting for Confluence Server & Data Center, Comala Workflow

Apps

Reporting for Confluence Server & Data Center, Comala Workflow

Level

Advanced

Estimated time

40 minutes

Macros

 

Suppliers

 

Storage format

You can copy and paste this code into the Confluence Source Editor:

<h1>Document States</h1> <h2>Review 1</h2> <ac:structured-macro ac:macro-id="83351ac0-82eb-4fd7-8c4e-4dfff08a0f99" ac:name="report-table" ac:schema-version="1"> <ac:rich-text-body> <ac:structured-macro ac:macro-id="5569477f-878e-4545-b1f6-d658b3233e65" ac:name="content-reporter" ac:schema-version="1"> <ac:parameter ac:name="types">page</ac:parameter> <ac:parameter ac:name="scope">DV:Review 1&gt;descendants</ac:parameter> <ac:parameter ac:name="spaces"> <ri:space ri:space-key="DV" /> </ac:parameter> <ac:rich-text-body> <p class="auto-cursor-target"> <ac:structured-macro ac:macro-id="518e9b83-17a6-475f-8266-a921f7423435" ac:name="text-filter" ac:schema-version="1"> <ac:parameter ac:name="required">true</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter> </ac:structured-macro> </p> <p class="auto-cursor-target"> <ac:structured-macro ac:macro-id="bd038b73-a459-42b4-be54-3ed4af3b9f3b" ac:name="text-sort" ac:schema-version="1"> <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="e95dd93f-7658-47bd-8d1f-0fc4f1510604" 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="e7ee31c4-dee3-4e73-a048-371f8fc5bdd3" 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="95db6743-0f41-4c1d-ab19-bc36c189e73f" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">State</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="52c62de5-ae99-459b-ab74-f865866dfd40" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="">workflow:state&gt;name</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="832a4e9c-0887-4d23-9d57-9daf5616937c" 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&gt;version</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&gt;date</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="3f1b5b9c-ace5-493e-835c-ae23d1a62458" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">Last published</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="b7b18218-8287-40ae-85ab-98f1f804b1f1" ac:name="report-block" ac:schema-version="1"> <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="bac347c8-77ad-4a35-932e-46aaab6bed56" ac:name="local-reporter" ac:schema-version="1"> <ac:parameter ac:name="">@self</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="da7e3034-5b53-4b0c-9bd0-c65819d3610f" ac:name="text-filter" ac:schema-version="1"> <ac:parameter ac:name="required">true</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="36d741dc-a0a0-4dd9-a587-8c2d99e15dd8" ac:name="report-body" ac:schema-version="1"> <ac:rich-text-body> <p>v.<ac:structured-macro ac:macro-id="f8c01d53-1c4b-4114-99db-1464c006d8f7" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; version</ac:parameter> </ac:structured-macro> on <ac:structured-macro ac:macro-id="4000c36f-831d-44a3-b2c0-af540d28c7dc" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; date</ac:parameter> </ac:structured-macro> by <ac:structured-macro ac:macro-id="e88b06da-ef9a-43ea-a595-5fb818ef7c76" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="link">true</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; user</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="9cf9ea61-f422-4d0b-8dc4-fcba4ec6a977" ac:name="report-empty" ac:schema-version="1"> <ac:rich-text-body> <p>Has not been published</p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="ca9bc8a8-acd3-41fa-a2e5-e0302bd058cf" ac:name="report-empty" ac:schema-version="1"> <ac:rich-text-body> <p>No results found</p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> <h2>Review 2</h2> <ac:structured-macro ac:macro-id="7724a0dd-f561-40e1-afb1-be90199e2b00" ac:name="report-table" ac:schema-version="1"> <ac:rich-text-body> <ac:structured-macro ac:macro-id="7286ca51-b55a-4061-9855-d5e9d8075a8e" ac:name="content-reporter" ac:schema-version="1"> <ac:parameter ac:name="types">page</ac:parameter> <ac:parameter ac:name="scope">DV:Review 2 &gt;descendants</ac:parameter> <ac:parameter ac:name="spaces"> <ri:space ri:space-key="DV" /> </ac:parameter> <ac:rich-text-body> <p class="auto-cursor-target"> <ac:structured-macro ac:macro-id="1d1ea817-cfa5-4ec2-bc14-0c0a85746ac5" ac:name="text-filter" ac:schema-version="1"> <ac:parameter ac:name="required">true</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter> </ac:structured-macro> </p> <p class="auto-cursor-target"> <ac:structured-macro ac:macro-id="556788b2-b1da-48af-82ff-3670867d44e9" ac:name="text-sort" ac:schema-version="1"> <ac:parameter ac:name="">content:title</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <p> <br /> </p> <p> <br /> </p> <ac:structured-macro ac:macro-id="69ae9b13-2388-42f8-a258-d1267302a1dd" 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="4c9728e5-8d3a-455c-8bd1-aee58a56bd09" 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="8bd118a0-66da-42d7-8ed1-378436015410" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">State</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="77df735c-4e8c-4967-b283-0260081080c4" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="9bad880b-a102-497e-a1b0-b15f32ed848c" 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="8a36324e-45d2-433e-87a8-ac2459bae8bc" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;version</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="aa1e2add-1d57-4cd2-84ba-10eb3cb98081" 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="7af28ab8-1feb-4494-a828-083d17e09546" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;date</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="30d4f445-7a8b-43ad-a0ab-24d7a0c99fa3" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">Last published</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="ffb4df00-9783-4e76-bb4e-185ebc66e22e" ac:name="report-block" ac:schema-version="1"> <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="254036e5-adaf-4e5e-b771-8fbc8d0022a1" ac:name="local-reporter" ac:schema-version="1"> <ac:parameter ac:name="">@self</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="50fc14ca-c59e-456b-b97b-ef71183fcc10" ac:name="text-filter" ac:schema-version="1"> <ac:parameter ac:name="required">true</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="d1a6fdaf-e871-48e5-b887-8a1624b1376a" ac:name="report-body" ac:schema-version="1"> <ac:rich-text-body> <p>v.<ac:structured-macro ac:macro-id="473a9440-c417-4b0c-a15f-e081d0d54c25" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; version</ac:parameter> </ac:structured-macro> on <ac:structured-macro ac:macro-id="da35856e-4824-46e1-9c46-03688e377269" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; date</ac:parameter> </ac:structured-macro> by <ac:structured-macro ac:macro-id="6561b8fb-4a17-438c-ad0c-8f41a4ec5e51" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="link">true</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; user</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="1845ee95-15eb-4a84-a141-edfd88807dcd" ac:name="report-empty" ac:schema-version="1"> <ac:rich-text-body> <p>Has not been published</p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="f748a42e-636b-4070-b673-bc87ff0e6a43" ac:name="report-empty" ac:schema-version="1"> <ac:rich-text-body> <p>No results found</p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> <h2>Review 3</h2> <ac:structured-macro ac:macro-id="06644514-ddc0-4022-8313-1f5b496d33b5" ac:name="report-table" ac:schema-version="1"> <ac:rich-text-body> <ac:structured-macro ac:macro-id="5d859734-7ffc-47ff-8e65-a4982cae09be" ac:name="content-reporter" ac:schema-version="1"> <ac:parameter ac:name="types">page</ac:parameter> <ac:parameter ac:name="scope">DV:Review 3 &gt;descendants</ac:parameter> <ac:parameter ac:name="spaces"> <ri:space ri:space-key="DV" /> </ac:parameter> <ac:rich-text-body> <p class="auto-cursor-target"> <ac:structured-macro ac:macro-id="8901bcc6-dab0-47c2-bb44-1d694b4f115f" ac:name="text-filter" ac:schema-version="1"> <ac:parameter ac:name="required">true</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter> </ac:structured-macro> </p> <p class="auto-cursor-target"> <ac:structured-macro ac:macro-id="f599976c-a7b2-4156-857c-30caf09d6c70" ac:name="text-sort" ac:schema-version="1"> <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="b4c1fcd1-bec9-446e-9a53-ef7be687d21c" 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="a8747984-ab04-4dc4-b094-81bbccf1bc8e" 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="1602ce8b-c1ec-4556-8550-89f59ea1fa2d" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">State</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="f20230b1-8534-4ab9-bdfc-9facef58f486" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="f7a76758-898b-4251-a485-aa1dddb085a8" 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="5a16ea9c-f6af-4e3f-9f31-b1e5e5f15bd5" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;version</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="d9e1d638-ca43-44a0-b3a7-3479c689b623" 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="87812064-7f69-46f2-be1e-1e0da89cfa0f" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;date</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="5308ea2d-16a7-469c-a029-4def74a5f09e" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">Last published</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="0715c2b4-ccfd-4482-8071-21c38b9404bd" ac:name="report-block" ac:schema-version="1"> <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="346bfec0-9ac2-4352-9a9e-ec6a3364ca26" ac:name="local-reporter" ac:schema-version="1"> <ac:parameter ac:name="">@self</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="424665b1-5339-4c6b-92f8-58ce82401bdb" ac:name="text-filter" ac:schema-version="1"> <ac:parameter ac:name="required">true</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="2d2c34ef-ede3-42c1-8196-a9eefb00228d" ac:name="report-body" ac:schema-version="1"> <ac:rich-text-body> <p>v.<ac:structured-macro ac:macro-id="a13aa6f3-ce78-44ad-b1fe-6d25a58cec63" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; version</ac:parameter> </ac:structured-macro> on <ac:structured-macro ac:macro-id="d723c139-119d-475c-8c5c-42e72b0833f7" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; date</ac:parameter> </ac:structured-macro> by <ac:structured-macro ac:macro-id="e326bf2e-4bb6-499c-87c8-62205c0ee9f2" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="link">true</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; user</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="3d39e572-39f2-4624-aa3a-cde38e573b19" ac:name="report-empty" ac:schema-version="1"> <ac:rich-text-body> <p>Has not been published</p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="7529f7af-b916-4de4-a9ff-ae11ffc8e951" ac:name="report-empty" ac:schema-version="1"> <ac:rich-text-body> <p>No results found</p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> <h2>Review 4</h2> <ac:structured-macro ac:macro-id="1e9d86c3-d023-4a36-8b8f-cd7f8af1f6e9" ac:name="report-table" ac:schema-version="1"> <ac:rich-text-body> <ac:structured-macro ac:macro-id="5f7d739a-21a8-49bb-88da-d935298cebc9" ac:name="content-reporter" ac:schema-version="1"> <ac:parameter ac:name="types">page</ac:parameter> <ac:parameter ac:name="scope">DV:Review 4 &gt;descendants</ac:parameter> <ac:parameter ac:name="spaces"> <ri:space ri:space-key="DV" /> </ac:parameter> <ac:rich-text-body> <p class="auto-cursor-target"> <ac:structured-macro ac:macro-id="34254497-9a3a-4fa7-b795-2cb6afcff115" ac:name="text-filter" ac:schema-version="1"> <ac:parameter ac:name="required">true</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter> </ac:structured-macro> </p> <p class="auto-cursor-target"> <ac:structured-macro ac:macro-id="63971b87-6bf4-4371-b01d-d02c263425db" ac:name="text-sort" ac:schema-version="1"> <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="a1c3ea50-e728-4c43-ae4a-21ada06ace01" 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="17079693-a978-4c40-96f2-192506dc22ea" 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="79cf2532-a926-4481-8f4e-07eb2cda0aae" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">State</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="b6b2ec3d-e7a4-47ff-b1df-0c0a1d34d567" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="">workflow:state&gt;name</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="8b861b41-397e-414b-a2d6-50866ef1fe61" 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="ff55d722-9bcf-45fd-a147-e18e8cce992f" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;version</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="289e68b9-a8dc-4b8f-ab43-32d1da5c9d8c" 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="862e3ba2-d5b4-4f3f-b7cf-68271410c408" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:state&gt;date</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="de22c6ad-0500-4105-ab3b-4cf0c19c6eef" ac:name="report-column" ac:schema-version="1"> <ac:parameter ac:name="title">Last published</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="c390392a-bdbb-482e-a1f4-ea6aa42121e3" ac:name="report-block" ac:schema-version="1"> <ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter> <ac:rich-text-body> <ac:structured-macro ac:macro-id="03c0c6fa-679c-4bcf-ba0d-ffaaa459271b" ac:name="local-reporter" ac:schema-version="1"> <ac:parameter ac:name="">@self</ac:parameter> <ac:rich-text-body> <p> <ac:structured-macro ac:macro-id="a2577acc-f551-403d-ba0f-c387211784af" ac:name="text-filter" ac:schema-version="1"> <ac:parameter ac:name="required">true</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="fd5491b2-b564-447d-8d5d-46ad35ecef7f" ac:name="report-body" ac:schema-version="1"> <ac:rich-text-body> <p>v.<ac:structured-macro ac:macro-id="9e06784e-d229-4a15-ab0b-d74bdf76fc53" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; version</ac:parameter> </ac:structured-macro> on <ac:structured-macro ac:macro-id="06aca349-7f92-449f-a7ed-9bd6a40d66fb" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; date</ac:parameter> </ac:structured-macro> by <ac:structured-macro ac:macro-id="199b0dcb-1fea-4d35-a021-74a959af5068" ac:name="report-info" ac:schema-version="1"> <ac:parameter ac:name="default">?</ac:parameter> <ac:parameter ac:name="format">dd MMM, yyyy</ac:parameter> <ac:parameter ac:name="link">true</ac:parameter> <ac:parameter ac:name="">workflow:states &gt; Published &gt; last &gt; user</ac:parameter> </ac:structured-macro> </p> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="e0ea95be-8364-4df0-b92e-816c67693c18" ac:name="report-empty" ac:schema-version="1"> <ac:rich-text-body> <p>Has not been published</p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro> <ac:structured-macro ac:macro-id="51ea5b2c-406f-4b8e-ae8d-ed4de79ef1bd" ac:name="report-empty" ac:schema-version="1"> <ac:rich-text-body> <p>No results found</p> </ac:rich-text-body> </ac:structured-macro> </ac:rich-text-body> </ac:structured-macro>

Macro structure

You can recreate the example in the editor view:

Steps

  1. Inside the Report Table macro, create a Content Reporter macro.

  2. Inside the Content Reporter macro, add a Text Filter macro and set:

    1. Key to 'workflow:state>name'

    2. Required = True

  3. Inside the Content Reporter macro, add a Text Sort macro and set:

    1. Key to "content:title"

    2. Order to ascending

    3. Mode to natural

  4. Then, within the Report Table, create these columns by following these steps:

Column

Steps

Column

Steps

Page Title

  1. Add a Report Column macro and set the title to "Page Title".

  2. Inside the Report column add a Report Info macro and set:

    1. Key to "content:title"

    2. Link To Item = True

    3. Render = none

State

  1. Add a Report Column macro and set the title to "State".

  2. Inside the Report column add a Report Info macro and set the Key to 'workflow:state>name".

Version

  1. Add a Report Column macro and set the Title to "Version".

  2. Inside the Report column add a Report Info macro and set:

    1. Key to "workflow:state>version"

    2. Link to Item = true

State changed on

  1. Within the Report Table macro, add a Report Column macro and set the Title to "State changed on".

  2. Inside the Report Column add a Report Info macro and set

    1. Key to 'workflow:state>date'

    2. Format to "dd MMM, yyyy"

Last published

  1. Add another Report Column macro and set Title to "Last Published".

  2. Inside the Report column, add a Report Block macro.

  3. Inside the Report Block, add a Local Reporter macro.

  4. Add a Text Filter to the Local Reporter and set: 

    1. Key to 'workflow:states > Published'

    2. Required = True

  5. Inside the Report Column, add a Report Body macro.

  6. Within the Report Body  

    1. Type "v." then add the Report Info macro. Set the Key to "workflow:states > Published > last > version"

    2. Type "on" and then add another Report Info macro. Set the Key to "workflow:states > Published > last > date"

    3. Type "by" and then add another Report info and set the Key to "workflow:states > Published > last > user"

  7. Inside the Report Block macro add Report Empty and type "Has not been published".

Finally, within the Report Table macro Inside the Report Table macro, add another Report Empty and type "No results found".

Â