/
List the Comala statuses of pages in a space

List the Comala statuses of pages in a space

Scenario

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

Result

Recipe

Apps

Reporting for Confluence 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. Create a Report Tabla macro.

  2. Within the Report Table macro, create a Content Reporter macro.

  3. Within the Content Reporter macro, create a Text Filter macro with the following parameters:

    • Key: workflow:state>name

    • Required: selected

  4. Within the Content Reporter macro, under the Text Filter macro, create a Text Sort macro with the following parameters:

    • Key: content:title

    • Order: ascending

    • Mode: natural

  5. Within the Report Table macro, under the Content Reporter macro, create the following columns:

Column

Steps

Column

Steps

Page Title

  1. Create a Report Column macro with Title: Page Title.

  2. Within the Report Column macro, create a Report Info macro with the following parameters:

    • Key: content:title

    • Link To Item: selected

    • Render: none

State

  1. Create a Report Column macro Title: State.

  2. Within the Report Column macro, create a Report Info macro with Key: workflow:state>name.

Version

  1. Create a Report Column macro with Title: Version.

  2. Within the Report Column macro, create a Report Info macro with the following parameters:

    • Key: workflow:state>version

    • Link to Item: selected

State changed on

  1. Create a Report Column macro with Title: State changed on.

  2. Within the Report Column macro, create a Report Info macro with the following parameters:

    • Key: workflow:state>date

    • Format: dd MMM, yyyy

Last published

  1. Create a Report Column macro with Title: Last Published.

  2. Within the Report Column macro, create a Report Block macro.

  3. Within the Report Block, create a Local Reporter macro.

  4. Within the Local Reporter macro, create a Text Filter with the following parameters:

    • Key: workflow:states > Published

    • Required: selected

  5. Within the Report Column, under the Local Reporter macro, create a Report Body macro.

  6. Within the Report Body,

    1. Enter v. and create a Report Info macro with Key: workflow:states > Published > last > version.

    2. Enter on and create another Report Info macro with Key: workflow:states > Published > last > date.

    3. Enter by and create another Report Info macro with Key: workflow:states > Published > last > user.

  7. Within the Report Block, under the Report Body macro, create a Report Empty macro with the following text in the macro body:

    Has not been published

  1. Within the Report Table macro, under the Report Column macros, create another Report Empty macro with the following text in the macro body:

    No results found