Showing Users Who Are Celebrating Their Birthday Today
Scenario
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 > date:MMdd > text:as number%</ac:parameter> <ac:parameter ac:name="maxValue">%global:current date > date:MMdd > text:as number%</ac:parameter> <ac:parameter ac:name="">data:birthDate > date:MMdd > 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