Scenario

...

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 Result 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. Let’s set up the parent page query.

   In the Reporting window, under QueryQuery section on the left, type the Confluence Query Language (CQL) syntax that will allow you to search for to find 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 let’s expand to retrieve child and descendant pages. In the Add expansionsExpansions 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 Removed

   Let’s build the first column for the report (leftmost column), which will contain the Parent pagecheck these boxes:

   • children > page

   • descendants > page
     

     Image Added

4. Now, let’s 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 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. For Block title, type Parent page, and set the Value to content.title.

   3. Click on the Block box and type Parent Page next to Block title page and next to Value, select content.title to show the title of the parent page. For this example, it is Get Started.  
      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. For the Direct Children Countcolumn, add another block, 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. Repeat creating a 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

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

...