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.

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?

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

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"

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"

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"

In the "Status" Report Column macro

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

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"

Use Cases

Part 2 - Creating the admin dashboard

Overview

Source code

Steps

Add the report table structure

Add the reporting columns

Add a report footer

Macro structure

Next