How do I display Status Macro selected from a Scaffolding form into a Reporting table?

[#1]

You can create an IF ELSE statement using Reporting to display Status Macro selected from a Scaffolding form.

Here's what you need:

• Scaffolding add-on
• Reporting add-on
• Scaffold Data Supplier

Outcome:

Edit page structure:

Storage format:

<h3 class="auto-cursor-target">Enter project name and select the status:</h3><ac:structured-macro ac:name="table-data" ac:schema-version="1" ac:macro-id="0022dcfb-82a6-4120-93a2-09eff255f04a"><ac:parameter ac:name="name">mytable</ac:parameter><ac:rich-text-body>
<table class="wrapped"><colgroup><col /><col /></colgroup>
<tbody>
<tr>
<th>
<p>Title</p></th>
<th>
<p>Status</p></th></tr>
<tr>
<td>
<div class="content-wrapper"><ac:structured-macro ac:name="text-data" ac:schema-version="1" ac:macro-id="64f7715e-e0cf-4b65-87ec-3a9eb4373d8e"><ac:parameter ac:name="name">mytitle</ac:parameter><ac:parameter ac:name="type">line</ac:parameter><ac:parameter ac:name="content">text</ac:parameter><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p></div></td>
<td>
<div class="content-wrapper"><ac:structured-macro ac:name="list-data" ac:schema-version="1" ac:macro-id="850c3f36-e248-46c3-bf2a-d0490e2bd41d"><ac:parameter ac:name="name">mystatus</ac:parameter><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="list-option" ac:schema-version="1" ac:macro-id="2a74714e-fa90-434b-b5ae-768eeebfb2d5"><ac:parameter ac:name="value">Approved</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="status" ac:schema-version="1" ac:macro-id="d62f9782-960d-4398-bf5d-f43c64fcb8cf"><ac:parameter ac:name="color">green</ac:parameter><ac:parameter ac:name="title">Approved</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="list-option" ac:schema-version="1" ac:macro-id="cd26b663-f7a7-4646-bf14-a9b5161bd258"><ac:parameter ac:name="value">Rejected</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="status" ac:schema-version="1" ac:macro-id="a51b416e-4ff4-45e2-85ee-34e1add74064"><ac:parameter ac:name="color">red</ac:parameter><ac:parameter ac:name="title">Rejected</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="list-option" ac:schema-version="1" ac:macro-id="422eee78-d0c5-48ad-a8b4-7181a11bd2ac"><ac:parameter ac:name="value">In Progress</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="status" ac:schema-version="1" ac:macro-id="301603e4-73f5-4fbb-9c4d-ef0a875dd4d4"><ac:parameter ac:name="color">yellow</ac:parameter><ac:parameter ac:name="title">In Progress</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="list-option" ac:schema-version="1" ac:macro-id="ea824718-a4b8-4b39-99c6-d8e033949bf8"><ac:parameter ac:name="value">Unassigned</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="status" ac:schema-version="1" ac:macro-id="05cea2f5-98a7-48d4-884d-a89b07a182c2"><ac:parameter ac:name="color">grey</ac:parameter><ac:parameter ac:name="title">Unassigned</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p></div></td></tr></tbody></table>
<p class="auto-cursor-target"><br /></p></ac:rich-text-body></ac:structured-macro>
<p><br /></p>
<hr />
<h3>Display the project name and selected status:</h3><ac:structured-macro ac:name="report-table" ac:schema-version="1" ac:macro-id="485be0b3-49d9-44d0-9703-240f31c4aaa3"><ac:rich-text-body><ac:structured-macro ac:name="local-reporter" ac:schema-version="1" ac:macro-id="2ebbf8da-c12e-41eb-981b-37b16eec1b86"><ac:parameter ac:name="source">@self</ac:parameter><ac:parameter ac:name="">data:mytable</ac:parameter><ac:rich-text-body>
<p><br /></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-column" ac:schema-version="1" ac:macro-id="a26f3205-ed4f-4aa2-aa60-81f94fde9409"><ac:parameter ac:name="title">Title</ac:parameter><ac:rich-text-body>
<p><ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="be76f63a-cb40-4956-aac6-e8abed13d7e0"><ac:parameter ac:name="">data:mytitle</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-column" ac:schema-version="1" ac:macro-id="fb8e39c2-3620-4f70-9ee2-1a6bc07d417a"><ac:parameter ac:name="title">Status</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="report-block" ac:schema-version="1" ac:macro-id="aa92bad9-edfa-4e4f-bdd0-d7db14c4b6f3"><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="local-reporter" ac:schema-version="1" ac:macro-id="176cffab-744c-45e9-bcc6-b211457f777b"><ac:parameter ac:name="">@self</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="text-filter" ac:schema-version="1" ac:macro-id="12cac7c6-8f28-4589-843b-f89a4bab1ed0"><ac:parameter ac:name="include">.*Approved.*</ac:parameter><ac:parameter ac:name="">data:mystatus</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-body" ac:schema-version="1" ac:macro-id="527c7c66-faff-4863-ae9c-e2f03b3ed491"><ac:rich-text-body><ac:structured-macro ac:name="status" ac:schema-version="1" ac:macro-id="e15c4b5d-b1ce-46da-9279-549b54db9123"><ac:parameter ac:name="color">green</ac:parameter><ac:parameter ac:name="title">Approved</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-block" ac:schema-version="1" ac:macro-id="421181a5-c259-4351-b8ec-22767f3cc2c5"><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="local-reporter" ac:schema-version="1" ac:macro-id="7982629e-02c0-474a-805c-01d47b02567c"><ac:parameter ac:name="">@self</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="text-filter" ac:schema-version="1" ac:macro-id="525efb4b-429e-4a17-b0a2-7f16c746a898"><ac:parameter ac:name="include">.*Rejected.*</ac:parameter><ac:parameter ac:name="">data:mystatus</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-body" ac:schema-version="1" ac:macro-id="f0a27872-dd1a-4883-9452-87cdf875fbca"><ac:rich-text-body><ac:structured-macro ac:name="status" ac:schema-version="1" ac:macro-id="46980c33-6c89-4d84-b066-f83ab9f99d30"><ac:parameter ac:name="color">red</ac:parameter><ac:parameter ac:name="title">Rejected</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-block" ac:schema-version="1" ac:macro-id="dc958f7e-3f83-4de9-8956-95ff6ddb8b59"><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="local-reporter" ac:schema-version="1" ac:macro-id="cb1f3108-5978-47ba-9b33-4e3d2be7fa8c"><ac:parameter ac:name="">@self</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="text-filter" ac:schema-version="1" ac:macro-id="aab1f263-d01e-4291-bf18-0cefc3be128e"><ac:parameter ac:name="include">.*In Progress.*</ac:parameter><ac:parameter ac:name="">data:mystatus</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-body" ac:schema-version="1" ac:macro-id="50371917-726e-4436-8647-c079ed9eb21d"><ac:rich-text-body><ac:structured-macro ac:name="status" ac:schema-version="1" ac:macro-id="4dad56ad-7ea1-4ade-807b-9d58cf90df8b"><ac:parameter ac:name="color">yellow</ac:parameter><ac:parameter ac:name="title">In Progress</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-block" ac:schema-version="1" ac:macro-id="7ef00e1f-ba24-4aac-9c00-f909d4856e4c"><ac:parameter ac:name="atlassian-macro-output-type">INLINE</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="local-reporter" ac:schema-version="1" ac:macro-id="635d4f1d-917d-406e-83ea-ddb2f6d53ec7"><ac:parameter ac:name="">@self</ac:parameter><ac:rich-text-body><ac:structured-macro ac:name="text-filter" ac:schema-version="1" ac:macro-id="82be5656-d3fe-4622-8bac-d206728a7faf"><ac:parameter ac:name="include">.*Unassigned.*</ac:parameter><ac:parameter ac:name="">data:mystatus</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro><ac:structured-macro ac:name="report-body" ac:schema-version="1" ac:macro-id="eecc3656-e33e-4ff5-8539-e2a9b0ad9153"><ac:rich-text-body><ac:structured-macro ac:name="status" ac:schema-version="1" ac:macro-id="9e01eddc-5d65-40d9-bc8d-524f180a4eaf"><ac:parameter ac:name="color">grey</ac:parameter><ac:parameter ac:name="title">Unassigned</ac:parameter></ac:structured-macro></ac:rich-text-body></ac:structured-macro></ac:rich-text-body></ac:structured-macro></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p></ac:rich-text-body></ac:structured-macro>
<p class="auto-cursor-target"><br /></p>

[466213]

Having trouble seeing expected results using Confluence 5.8.18. I have tried results in this article as well as similar article Creating an IF ELSE statement with Reporting - Reporting. With both I have outright copied the storage format code into a blank page and encountering failure.

One idea is the Text Filter simply is not attaining the scaffold data as expected, which results in the report table being blank.However, in the related article I mentioned there are details of a second method which uses a Local Reporter with keychain "data:mystatus > collection:first > text:find In Progress" (using In Progress, as example). This other method also fails to produce the expected report. So is the issue with Local Reporter and scaffold data?

Anyone with any ideas where to begin my troubleshooting?

[Sayed Bares [ServiceRocket]]

Hi Gary,

When you import the above storage format into a blank page, what do you see?

In the meantime, can you please open a ticket in Success.servicerocket.com 

that way we can troubleshoot this issue faster.

Regards,

Sayed Bares