How to group a combining reporter?

  • 1
  • Problem
  • Updated 2 years ago
Hello,

Here is my configuration:
  • Confluence 5.10.3
  • Reporting 6.4.8
  • Scaffolding 8.7.11
I am building a synthesis page of several project pages based on Reporting and Scaffolding.

A project page contains several table-data:


I have combined several Expanding reporters in my synthesis page:



It all works well, I get the data I need. The issue is that I would need to sort the synthesis table by B values.
I tried Grouping reporter > Combining reporter > (Expanding reporters > Content reporters) but I can't find the right key for the Grouping reporter.
I also tried several keys for a Text sort but still can't find the right one.

Is there a way to do this?

Thanks,
Manon
Photo of Manon

Manon

  • 3 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 1
Photo of Nurhana Ziana Bt. Hanafi

Nurhana Ziana Bt. Hanafi, Employee

  • 3500 Posts
  • 269 Reply Likes
Hello Manon,

Can you provide us storage format of the Reporting page, for our testing?

Thanks&Regards,
Ziana
(Edited)
Photo of Manon

Manon

  • 3 Posts
  • 0 Reply Likes
Hello Ziana,

Here is the storage format of the synthesis page:

<ac:structured-macro ac:name="report-table" ac:schema-version="1" ac:macro-id="d75532af-ae9a-4ffa-9a15-1a9d0ea37175">
    <ac:rich-text-body>
        <ac:structured-macro ac:name="combining-reporter" ac:schema-version="1" ac:macro-id="9b6c9c0d-9514-4d78-949c-e5b979d7494d">
            <ac:rich-text-body>
                <ac:structured-macro ac:name="expanding-reporter" ac:schema-version="1" ac:macro-id="996e94ee-b181-401d-83d9-2dc3c88785d4">
                    <ac:parameter ac:name="as">1</ac:parameter>
                    <ac:parameter ac:name="">data:1</ac:parameter>
                    <ac:rich-text-body>
                        <ac:structured-macro ac:name="content-reporter" ac:schema-version="1" ac:macro-id="a290721d-f73c-4859-a950-b90b0929e4ac">
                            <ac:parameter ac:name="types">page</ac:parameter>
                            <ac:parameter ac:name="scope">HomePage &gt; descendents</ac:parameter>
                            <ac:parameter ac:name="labels">ul</ac:parameter>
                            <ac:rich-text-body>&nbsp;</ac:rich-text-body>
                        </ac:structured-macro>
                    </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:name="expanding-reporter" ac:schema-version="1" ac:macro-id="74eea7d2-d95c-4da0-b524-7fc1f2a8ea0b">
                    <ac:parameter ac:name="as">2</ac:parameter>
                    <ac:parameter ac:name="">data:2</ac:parameter>
                    <ac:rich-text-body>
                        <ac:structured-macro ac:name="content-reporter" ac:schema-version="1" ac:macro-id="eb37b3f2-e6f4-47cf-94c7-26e7864847f3">
                            <ac:parameter ac:name="types">page</ac:parameter>
                            <ac:parameter ac:name="scope">HomePage &gt; descendents</ac:parameter>
                            <ac:parameter ac:name="labels">ul</ac:parameter>
                            <ac:rich-text-body>&nbsp;</ac:rich-text-body>
                        </ac:structured-macro>
                    </ac:rich-text-body>
                </ac:structured-macro>
                <ac:structured-macro ac:name="expanding-reporter" ac:schema-version="1" ac:macro-id="7fa45af6-1dd7-4e60-8a88-4c3f417bdbfa">
                    <ac:parameter ac:name="as">3</ac:parameter>
                    <ac:parameter ac:name="">data:3</ac:parameter>
                    <ac:rich-text-body>
                        <ac:structured-macro ac:name="content-reporter" ac:schema-version="1" ac:macro-id="56db9f96-acba-435f-9adc-d85770e90a59">
                            <ac:parameter ac:name="types">page</ac:parameter>
                            <ac:parameter ac:name="scope">HomePage &gt; descendents</ac:parameter>
                            <ac:parameter ac:name="labels">ul</ac:parameter>
                            <ac:rich-text-body>&nbsp;</ac:rich-text-body>
                        </ac:structured-macro>
                    </ac:rich-text-body>
                </ac:structured-macro>
            </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:name="report-column" ac:schema-version="1" ac:macro-id="0cb70651-2225-4878-ac06-220f4bd1f1a5">
            <ac:parameter ac:name="title">B</ac:parameter>
            <ac:rich-text-body>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="19ac8c6c-3b4b-4549-b906-a9ca60e49b39">
                        <ac:parameter ac:name="">expanded:1 &gt; data:B</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="a287e565-6f60-426e-b821-ce91be8c1ce0">
                        <ac:parameter ac:name="">expanded:2 &gt; data:B</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="f485fad1-64b4-421a-93f3-4228effd12a9">
                        <ac:parameter ac:name="">expanded:3 &gt; data:B</ac:parameter>
                    </ac:structured-macro>
                </p>
            </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:name="report-column" ac:schema-version="1" ac:macro-id="a8536465-dacd-490f-acd1-357d4ffeeb9c">
            <ac:parameter ac:name="title">A</ac:parameter>
            <ac:rich-text-body>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="f095647b-75f8-434c-8ddf-a242945b26fe">
                        <ac:parameter ac:name="">expanded:1 &gt; data:A</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="d640d2c8-3b5a-46f8-bdc8-1f887629b69c">
                        <ac:parameter ac:name="">expanded:2 &gt; data:A</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="79521e55-d7b6-4b7e-bf52-210c984106c1">
                        <ac:parameter ac:name="">expanded:3 &gt; data:A</ac:parameter>
                    </ac:structured-macro>
                </p>
            </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:name="report-column" ac:schema-version="1" ac:macro-id="a05d700c-fe7a-437e-a574-e5d105b750c7">
            <ac:parameter ac:name="title">C</ac:parameter>
            <ac:rich-text-body>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="913e9d66-14d0-4f49-893b-add84c789d25">
                        <ac:parameter ac:name="render">richtext</ac:parameter>
                        <ac:parameter ac:name="">expanded:1 &gt; data:C1</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="4051325e-e39e-4e04-8ebe-fc7db2fb1b47">
                        <ac:parameter ac:name="render">richtext</ac:parameter>
                        <ac:parameter ac:name="">expanded:1 &gt; data:C2</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="b20ad367-f8b5-4a0f-a57c-e8b46346e1c9">
                        <ac:parameter ac:name="render">richtext</ac:parameter>
                        <ac:parameter ac:name="">expanded:2 &gt; data:C1</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="b8f585e9-227c-4548-bca6-1f21dc7d1061">
                        <ac:parameter ac:name="render">richtext</ac:parameter>
                        <ac:parameter ac:name="">expanded:2 &gt; data:C2</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="18ac3093-7ab3-4270-a8c7-da160592a74e">
                        <ac:parameter ac:name="render">richtext</ac:parameter>
                        <ac:parameter ac:name="">expanded:3 &gt; data:C1</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>
                    <ac:structured-macro ac:name="report-info" ac:schema-version="1" ac:macro-id="b575c5a9-c77d-4c47-8b4f-dfc9e6a53b25">
                        <ac:parameter ac:name="render">richtext</ac:parameter>
                        <ac:parameter ac:name="">expanded:3 &gt; data:C2</ac:parameter>
                    </ac:structured-macro>
                </p>
            </ac:rich-text-body>
        </ac:structured-macro>
        <ac:structured-macro ac:name="report-column" ac:schema-version="1" ac:macro-id="a5a87451-ac26-4340-9fcb-e1f2d9e4e478">
            <ac:parameter ac:name="title">D</ac:parameter>
            <ac:rich-text-body>
                <p style="text-align: center;">&nbsp;</p>
                <p style="text-align: center;">
                    <ac:structured-macro ac:name="report-image" ac:schema-version="1" ac:macro-id="d41fb543-6d99-45ee-b890-c43ae465624c">
                        <ac:parameter ac:name="width">30px</ac:parameter>
                        <ac:parameter ac:name="">expanded:1 &gt; data:D &gt; collection:first &gt; attachment:download path</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p style="text-align: center;">
                    <ac:structured-macro ac:name="report-image" ac:schema-version="1" ac:macro-id="6823e779-b85e-4387-8d1f-b9fb6e45e508">
                        <ac:parameter ac:name="height">30px</ac:parameter>
                        <ac:parameter ac:name="">expanded:2 &gt; data:D &gt; collection:first &gt; attachment:download path</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p style="text-align: center;">
                    <ac:structured-macro ac:name="report-image" ac:schema-version="1" ac:macro-id="905c31e0-663f-458a-a73f-271c5681c608">
                        <ac:parameter ac:name="height">30px</ac:parameter>
                        <ac:parameter ac:name="">expanded:3 &gt; data:D &gt; collection:first &gt; attachment:download path</ac:parameter>
                    </ac:structured-macro>
                </p>
                <p>&nbsp;</p>
            </ac:rich-text-body>
        </ac:structured-macro>
    </ac:rich-text-body>
</ac:structured-macro>

Thanks,
Manon
Photo of Manon

Manon

  • 3 Posts
  • 0 Reply Likes
Hello Ziana,

Would you please have any update? Would you need any further information?

Thanks,
Manon