Scenario

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

Scenario

Create a report showing the number of direct child pages and all descendant pages of a specified parent page.

Result

...

Recipe

Steps

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

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

2. In the Reporting window, under Query, type Query section on the left, set up the parent page query by typing 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. For this example, use: type=page AND title="Get Started"will match all pages with the title "Get Started" in the current space.
   Click Search and to confirm that your CQL syntax is matching the the query matches your parent page.

3. Now continue to In the Add expansionsExpansions section, which helps you retrieve more data from your query. Check check the following boxes to retrieve all children child and descendants descendant pages of the “Get Started” page:

   • children

   and then page after expanding under children, similarly descendants and then page after expanding.

   • > page

   • descendants > page
     

     Image Modified

4. Let’s build the first column for the report (leftmost column), which will contain the Parent page. Go Now, start building the columns of your report. To display the Parent page title in the first column, go to the Add report blocks section to add the first block, which will also be your first column too.

   1. Make sure that Basic is selected in the dropdown, then click on Go to Add Report Blocks, select Basic, then Add block.

   2. Click on the Block box and type Parent Page next to Block title and next to Value, select content.title to show the title of the parent page. For this example, it is Get Started.  For Block title, type Parent page, and set the Value to content.title.
      
      Look at the screenshot to see how the block’s settings and preview should appear:

      

   Next, let’s add the second column of the report, which displays the count of direct child pages under the Get Started (parent) page.

5. Again, under Add report blocks choose Basic in the dropdown, then click on Add block.

Click on the Block box and type Direct Children Count next to Block title and next to Value, select

6. Add another block for the Direct Children Countcolumn, title it Direct Children Count, and set the Value to content.children.page.size

   to show the number of direct children of the Get Started page. For this example, it is 3.  

   Repeat step 5 for the last column, which displays the count descendant pages (indirect children) under the Get Started (parent) page. Type All Descendants Count for the Block title and choose

7. Finally, add the block for the third column, title it All Descendants Count, and set the Value to content.descendants.page.size.

7. Check the Preview and Save your report.
   The final block configuration should appear as shown in the screenshot below:

   Image Added

8. Publish the page, and you're done.

...