Scenario

A report that shows the count of all direct children pages and descendant (indirect children) pages of a page.

...

Steps

To build this the report shown in Result above, follow the these steps below:

1. Create a new page for the report and give it a suitable title. Then insert a Reporting macro.

2. In the Reporting window, under Query, type the Confluence Query Language (CQL) syntax that will allow you to search for the parent page, whose children and descendants you want to report on. Refer to this Atlassian article for more information on the CQL syntax.
   The example CQL below: type=page AND title="Get Started" will match all pages with the title "Get Started" in the current space???. Click Search and confirm that your CQL syntax is matching the parent page.

   Image Removed

3. Now continue to the Report Builder section. We Add expansions section, which helps you retrieve more data from your query. Check the following boxes to retrieve all children and descendants pages of the “Get Started” page: children and then page after expanding under children, similarly descendants and then page after expanding.

   Image Added

4. We'll start by building the first column for the report (leftmost column), which will contain the employee’s name.

   1. In the dropdown, Choose Scaffolding, then click on Add.

      Image RemovedImage Added

   2. Click on "Block 0", then under Title, key in "Name", and under Field Group Name, select the correct Field Group from the list. For this example, it is "profile_group". 

      

   3. Continue by clicking on Field Name. A list of fields will appear. Select the field that matches the title. For this example, it is "employee_name". Click Update to continue.

      

5. Next, we'll add the second column for the report, which will display employees' positions.

   1. Again, choose Scaffolding in the dropdown, then click on Add.

      

   2. Click on "Block 1", then under Title, key in "Position", and under Field Group Name, select the correct Field Group from the list. For this example, it is "profile_group". Click on Field Name. A list of fields will appear. Select the field that matches the title. For this example, it is "employee_position". Click Update to continue.

      

6. Repeat step 7 for the two remaining columns, "Start date" and "Employee ID". Make sure you match the field to the title each time.

7. Under Report Type, choose Table (the default). Then, we'll add some error handling by filling out the Empty Report section. This text is shown if the report has no results. For this example, we'll enter "No matching profiles were found. Please try again later." You will also see a preview of the report here.

   Image RemovedImage Added

8. Save your report, Publish the page, and you're done.

...

1. In Confluence or Jira, click on the People tab, and either select or search for the user you are interested in. View their profile.
   

   

2. The URL of their profile page will include their user account ID at the end. It will look a like string of random letters and numbers. You can copy this string and use it for CQL queries.
   

   Image RemovedImage Added

Notes

...