Table of Contents

minLevel	1
maxLevel	6
outline	false
type	flat
separator	pipe
printable	false

Overview

In Part 2, we will create the admin dashboard, which will allow admin to have a detailed overview of all created tasks by team members.

By the end of this section you should have something that looks like this:

Source code

The following source code is shared using Confluence Storage Format - the XHTML-based format that Confluence uses to store the content of pages, page templates, blueprints, blog posts and comments.

Info
For more information on how to use this source code on your Confluence, read the following article - How do I use Recipes that use the Storage Format with the Confluence Source Editor?

Expand

title	Source code

Code Block

    <ac:structured-macro ac:macro-id="c4f3574c-fc97-4542-a3ae-1f2da3b2efcb" ac:name="report-table" ac:schema-version="1">
      <ac:parameter ac:name="injected">true</ac:parameter>
      <ac:rich-text-body>
        <ac:structured-macro ac:macro-id="d13b3de0-03c7-4062-9e53-79bf4b0a710b" ac:name="expanding-reporter" ac:schema-version="1">
          <ac:parameter ac:name="as">Task</ac:parameter>
          <ac:parameter ac:name="">data:Task</ac:parameter>
          <ac:rich-text-body>
            <ac:structured-macro ac:macro-id="7afd4ea1-eef3-4ec7-b441-a28bc40694ca" ac:name="local-reporter" ac:schema-version="1">
              <ac:parameter ac:name="">page:children</ac:parameter>
              <ac:rich-text-body>
                <p>
                  <br/>
                </p>
              </ac:rich-text-body>
            </ac:structured-macro>
          </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:macro-id="4d15cd00-5537-4e16-8e84-7ac6d9bf0671" ac:name="report-column" ac:schema-version="1">
          <ac:parameter ac:name="injected">true</ac:parameter>
          <ac:parameter ac:name="title">Assignee</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:structured-macro ac:macro-id="b8f896b0-0ce0-4d60-aba5-a8c2af00ad2b" ac:name="report-info" ac:schema-version="1">
                <ac:parameter ac:name="">Task&gt;data:User</ac:parameter>
              </ac:structured-macro>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:macro-id="144ddd8d-b326-4071-b4e4-773b60c477d9" ac:name="report-column" ac:schema-version="1">
          <ac:parameter ac:name="title">Description</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:structured-macro ac:macro-id="eab678f6-0a92-42e0-9715-12eb7eacb4ff" ac:name="report-info" ac:schema-version="1">
                <ac:parameter ac:name="render">richtext</ac:parameter>
                <ac:parameter ac:name="">Task&gt;data:Description</ac:parameter>
              </ac:structured-macro>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:macro-id="3c63709b-334f-436e-b27e-f411dcebc414" ac:name="report-column" ac:schema-version="1">
          <ac:parameter ac:name="title">Due Date</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:structured-macro ac:macro-id="c091ebb3-30b3-44f9-b066-a18e0ca1f40b" ac:name="report-info" ac:schema-version="1">
                <ac:parameter ac:name="format">dd MMMM, yyyy</ac:parameter>
                <ac:parameter ac:name="">Task&gt;data:Due Date</ac:parameter>
              </ac:structured-macro>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:macro-id="c751c8ea-de06-41bb-a1d3-eb9a8d36a1d3" ac:name="report-column" ac:schema-version="1">
          <ac:parameter ac:name="title">Status</ac:parameter>
          <ac:rich-text-body>
            <p>
              <ac:structured-macro ac:macro-id="09bf8230-502c-4935-8998-2a0c634ab08b" ac:name="report-info" ac:schema-version="1">
                <ac:parameter ac:name="">Task&gt;data:Status</ac:parameter>
              </ac:structured-macro>
            </p>
          </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:macro-id="67a18664-776a-4320-9d1b-82a889b0a41e" ac:name="report-footer" ac:schema-version="1">
          <ac:rich-text-body>
            <table class="wrapped relative-table" style="width: 20.6701%;">
              <colgroup>
                <col style="width: 27.5482%;"/>
                <col style="width: 72.4518%;"/>
              </colgroup>
              <tbody>
                <tr>
                  <td class="highlight-red" colspan="2" data-highlight-colour="red" style="text-align: center;" title="Background colour : Red">
                    <p title="">Total Number of Tasks: </p>
                    <div class="content-wrapper" title="">
                      <p>
                        <ac:structured-macro ac:macro-id="4d430aff-a9d6-4053-b7c9-7401b6539883" ac:name="report-info" ac:schema-version="1">
                          <ac:parameter ac:name="">report:query&gt;size</ac:parameter>
                        </ac:structured-macro>
                      </p>
                    </div>
                  </td>
                </tr>
              </tbody>
            </table>
          </ac:rich-text-body>
        </ac:structured-macro>
      </ac:rich-text-body>
    </ac:structured-macro>

Steps

Table of Contents

minLevel	4
maxLevel	4
outline	false
type	list
printable	false

Add the report table structure

On a draft page

create a Report Table macro

Within the Report Table

add an Expanding Reporter macro
- set the Key parameter to "data:Task"
- set the As parameter to "Task"

In the Expanding Reporter

create a Local Reporter
set the Key parameter to "page:children"

Add the reporting columns

In the Report Table macro (below the Expanding Reporter macro)

add four Report Column macros
- set their titles to
  - "Assignee"
  - "Task Description"
  - "Due Date"
  - "Status"

In the "Assignee" Report Column macro

add a Report Info macro
- set its Key parameter to "Task>data:User"

Info
This is so we can get the value of the the Scaffolding User field.

In the "Task Description" Report Column macro

add a Report Info macro
- set the Key parameter to "Task>data:Description"

Info
This is so we can get the value of the Scaffolding Description field.

In the "Due Date" Report Column macro

add a Report Info macro
- set its Key parameter to "Task>data:Due Date"

Info
This is so we can get the value of the Scaffolding Due Date field.

In the "Status" Report Column macro

add a Report Info macro
- set its Key parameter to "Task>data:Status"

Info
This is so we can get the value of the Scaffolding Status field.

Add a report footer

After the last Report Column macro

add a Report Footer macro
add a 1x1 table in the Report Footer macro
- set a color as required - orange is used in this example

In the single table cell added to the Report Footer macro

type "Total Number of Tasks:"
add a Report Info macro
- set the Key parameter to "Report:query>size"

Macro structure

Image Removed

Image Added

Versions Compared

Old Version 7

New Version Current

Key

Overview

Source code

Steps

Add the report table structure

Add the reporting columns

Add a report footer

Macro structure

Next

Page Comparison

Versions Compared

Old Version 7

New Version Current

Key

Overview

Source code

Steps

Add the report table structure

Add the reporting columns

Add a report footer

Macro structure

Next