Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

  1. Create a new Confluence page, add a Reporting macro, and give the page a suitable title. Let’s set up the parent page query.

  2. In the Query section on the left, type set up the parent page query by typing the Confluence Query Language (CQL) syntax to find the parent page. For this example, use: type=page AND title="Get Started"
    Click Search to confirm the query matches your parent page.

  3. Now let’s expand to retrieve child and descendant pages. In the Add Expansions section, check these boxesthe following boxes to retrieve child and descendant pages:

    • children > page

    • descendants > page

      reporting-cql-expansions.png
  4. Now, let’s start building the columns of your report. To display the Parent page title in the first column. Go , go to the Add report blocks section to add the first block, which will also be your first column too.

    1. Go to Add Report Blocks, select Basic, then Add block.

    2. 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:

      Details of the first report block are shown, including the block title and value, with a preview of the first block displayed below.
  5. For Add another block for the Direct Children Countcolumn, add another block, title it Direct Children Count, and set the Value to content.children.page.size

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

...