Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

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

Here's what you need:

Outcome:

Screen Shot 2018-05-25 at 4.39.24 PM.png

Edit page structure:

Screen Shot 2018-05-25 at 4.43.34 PM.png

Screen Shot 2018-05-25 at 4.43.43 PM.png

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>

 

2 comments

Comment

Log in or Sign up to comment
466213
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 14, 2018

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]
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 15, 2018

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

TAGS
AUG Leaders

Atlassian Community Events