Overview

The team resourcing page lists all the subprojects and shows the list of members involved in each subproject.

In addition, the e-mail address for the most immediate contact person is shown in the final column.

For this project, 2 user groups are created

pmd-project-leaders - all the project leaders involved in the project
pmd-project-members - all the project members involved in the project

Suppliers used

When to use the Collection Supplier

Use the object supplier if you are unsure of the object type. Pair any key with an object:class keychain and it will return the type of object, for example:

data:Project Members > object:class returns

class java.util.ArrayList

This means the Project Members Scaffolding data is stored as an Array List.

This keychain is useful for debugging purposes.

Content and Structure

Set the main structure of our report, which is a table.

create a report-table macro

Next, define what to report. This is done by

adding a content-reporter block
nesting this block inside the report-table block
edit the content-reporter block to set
- Types to +pages, -attachment
- Labels to subproject
- Scope to Cafe Rockettoria Projects > children

Reporting only fetches pages labeled as subproject and is a children of Cafe Rockettoria Projects. The use of -attachment means that attachments are excluded.

In the content-reporter block

insert a text-sort block
edit the text-sort block
- type content:title for Key
- choose 'ascending' for Order

This sorts the pages in ascending order based on the page title.

Now we are ready to setup the report columns.

Project Name

Within the report-table block

insert a report-column macro underneath the content-reporter block
- name this column Project Name
insert a report-info block inside this report-column
edit the report-info block
- name the Key content:title
- check Link To Item

Reporting fetches the page titles.

Project Status

insert a report-column macro
- name this column Project Status
insert a report-info block inside this report-column
edit the report-info block
- name the Key data:Project Status

Reporting fetches the subproject status using the Scaffolding data block created in the live template.

Project Leader

insert a report-column macro
- name this column Project Leader
insert a report-info block inside this report-column
edit the report-info block
- name the Key data:Project Leader

Reporting fetches the subproject team leader using the Scaffolding data block created in the live template.

Project Members

insert a report-column macro
- name this column Project Members
insert a report-info block inside this report-column
- edit the report-info block
- name the Key data:Project Members
- set Separator to newline

This displays the name of each team member in a new line.

Reporting fetches the subproject team members using the Scaffolding data block created in the live template.

Contact

insert a report-column macro
- name this column Contact
insert a report-info block inside this report-column
edit the report-info block
- name the Key data:Project Leader > collection:first > user:email

Reporting fetches the subproject team leader email address by pairing it with the user:email keychain.

The Project Leader Scaffolding data block returns a list of users

the first item in the list is fetched (there is only one project leader in this perspective)
the user's email is returned based on the users profile page

Macro Structure

Full Source

<ac:structured-macro ac:macro-id="38aec1b2-1f0e-4759-8be8-e20dbcf76023" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="38314951-78e6-4773-b549-e46d953e2e5e" ac:name="content-reporter" ac:schema-version="1">
      <ac:parameter ac:name="types">+pages, -attachment</ac:parameter>
      <ac:parameter ac:name="scope">Cafe Rockettoria Projects &gt; children</ac:parameter>
      <ac:parameter ac:name="labels">subproject</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="d1e9c74e-605d-4a53-93f3-38d195a200b2" ac:name="text-sort" ac:schema-version="1">
            <ac:parameter ac:name="">content:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="aea2847c-88ea-4257-a597-ad46237c0264" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Project Name</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="59a534ec-dac2-4750-a69c-747c111a21ae" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="link">true</ac:parameter>
            <ac:parameter ac:name="">content:title</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="92c73454-6ef4-432a-b915-c55216fd744b" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Project Status</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="304641a2-8b08-4275-80a7-af69a6797359" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:Project Status</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="127bfac6-2465-4955-9001-dbfc3c473366" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Project Leader</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="8077ec40-d18e-486f-942d-1edce5e046df" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:Project Leader</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="bd0ed584-2fee-4988-b3ad-a0b3e4d3c0c8" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Project Members</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="0814da3c-04ce-44f0-a925-e86697b91436" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="separator">newline</ac:parameter>
            <ac:parameter ac:name="">data:Project Members</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="39a74550-b31c-4454-8f5e-aea4d03da68a" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Contact</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="7632605f-305b-4ba5-9010-bdaa40849858" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">data:Project Leader &gt; collection:first  &gt; user:email</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>

Part 7 - Creating the team resourcing page