Versions Compared

Old Version 10

changes.mady.by.user Elena Amandola

Saved on

compared with

New Version 11

changes.mady.by.user Elena Amandola

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 6

Scenario

Live template
templateTypetemplate
templateOption{"label":"Use Case livetemplate cloud ready","value":"475515452","templateType":"template"}
templateTypeOption{"label":"Confluence template/blueprint","value":"template"}
templateId475515452
excerptScenario Using the Report On macro combined with Scaffolding, you are able to extract a set of dates from a Scaffolding table.

...

This recipe shows you how to display users who are having their birthday today.

...

Result

...

Recipe

...

Apps

...

Reporting for Confluence Server & Data Center, Scaffolding Forms & Templates for Confluence Server and Data Center

...

Level

...

Easy

...

Estimated time

...

15 Minutes

...

Macros

...

Number Filter, Report On, Report Variable

...

Suppliers

...

Date Supplier, Scaffolding Data Supplier, Variable Supplier

...

Storage format

...

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

...

<p>

...

<strong>List

...

of

...

Birthdays</strong>

...

</p>

...

<ac:structured-macro

...

ac:macro-id="22439cf5-f14c-4da4-ad06-74d7c6bccc94"

...

ac:name="table-data"

...

ac:schema-version="1">

...

<ac:parameter

...

ac:name="">birthdayList</ac:parameter>

...

<ac:rich-text-body>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

<table>

...

<tbody>

...

<tr>

...

<th>

...

<p>Name</p>

...

</th>

...

<th>

...

<p>Birthdate</p>

...

</th>

...

</tr>

...

<tr>

...

<td>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

<ac:structured-macro

...

ac:macro-id="5cf48023-6c8f-45c7-a822-03bebfd7dba9"

...

ac:name="text-data"

...

ac:schema-version="1">

...

<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:parameter

...

ac:name="">name</ac:parameter>

...

<ac:rich-text-body>

...

<p>

...

<br

...

/>

...

</p>

...

</ac:rich-text-body>

...

</ac:structured-macro>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

</td>

...

<td>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

<ac:structured-macro

...

ac:macro-id="4aa57614-bd07-465a-b9f7-b57ebb47b766"

...

ac:name="date-data"

...

ac:schema-version="1">

...

<ac:parameter

...

ac:name="format">dd-MMM-yyyy</ac:parameter>

...

<ac:parameter

...

ac:name="atlassian-macro-output-type">INLINE</ac:parameter>

...

<ac:parameter

...

ac:name="">birthDate</ac:parameter>

...

</ac:structured-macro>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

</td>

...

</tr>

...

</tbody>

...

</table>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

</ac:rich-text-body>

...

</ac:structured-macro>

...

<p>

...

<strong>Who's

...

Celebrating

...

Today?</strong>

...

</p>

...

<ac:structured-macro

...

ac:macro-id="8012bf5a-8a86-4298-aa27-1baf31e95ce5"

...

ac:name="report-on"

...

ac:schema-version="1">

...

<ac:parameter

...

ac:name="injected">true</ac:parameter>

...

<ac:parameter

...

ac:name="atlassian-macro-output-type">INLINE</ac:parameter>

...

<ac:rich-text-body>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

<ac:structured-macro

...

ac:macro-id="324c9b60-b71c-4a36-be0b-368f8accdc48"

...

ac:name="report-block"

...

ac:schema-version="1">

...

<ac:parameter

...

ac:name="atlassian-macro-output-type">INLINE</ac:parameter>

...

<ac:rich-text-body>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

<ac:structured-macro

...

ac:macro-id="42600bb7-8902-4483-87cb-58f442eff515"

...

ac:name="local-reporter"

...

ac:schema-version="1">

...

<ac:parameter

...

ac:name="">data:birthdayList</ac:parameter>

...

<ac:rich-text-body>

...

<ac:structured-macro

...

ac:macro-id="2683a76a-d0db-4fa3-8f06-4dd705b216ac"

...

ac:name="number-filter"

...

ac:schema-version="1">

...

<ac:parameter

...

ac:name="minValue">%global:current

...

date

...

&gt;

...

date:MMdd

...

&gt;

...

text:as

...

number%</ac:parameter>

...

<ac:parameter

...

ac:name="maxValue">%global:current

...

date

...

&gt;

...

date:MMdd

...

&gt;

...

text:as

...

number%</ac:parameter>

...

<ac:parameter

...

ac:name="">data:birthDate

...

&gt;

...

date:MMdd

...

&gt;

...

text:as

...

number</ac:parameter>

...

</ac:structured-macro>

...

</ac:rich-text-body>

...

</ac:structured-macro>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

<ac:structured-macro

...

ac:macro-id="5a3850df-9eec-4dd8-94bb-b1a9144717ac"

...

ac:name="report-body"

...

ac:schema-version="1">

...

<ac:rich-text-body>

...

<p>

...

<ac:structured-macro

...

ac:macro-id="36a532a5-58a4-46f5-b9c6-d690a87a5ce0"

...

ac:name="report-info"

...

ac:schema-version="1">

...

<ac:parameter

...

ac:name="separator">comma</ac:parameter>

...

<ac:parameter

...

ac:name="">data:name</ac:parameter>

...

</ac:structured-macro>

...

</p>

...

</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>

...

</ac:rich-text-body>

...

</ac:structured-macro>

...

<p

...

class="auto-cursor-target">

...

<br

...

/>

...

</p>

...

Macro structure

...

You can recreate the example in the editor view:

...

Steps

...

N/A

...

Line-by-Line Explanation

...

N/A
fieldGroupKeys{"6aqnjkbqoz":["net.customware.confluence.plugin.scaffolding__6aqnjkbqoz__data_0_o3vkx44yap"]}