Combine Multiple ACS Commons Report to One Report

[aemUser2345]

I have multiple queries in JCR-SQL2 and are currently separated in multiple ACS commons reports. This is not very user friendly as we need to go through different reports to look for the data. I was wondering if there's any way to merge these reports into one?

[lukasz-m · Accepted solution]

Hi @ wenwang1,

Well probably the only option will be to combine multiple queries from various reports into one more complex query, e.g using JOINS or UNION.

• https://jackrabbit.apache.org/oak/docs/query/grammar-sql2.html

Nevertheless depending on the nature of queries, you are using in specific reports, this could only reduce number of reports but not to aggregate everything into one.

What you could consider as an alternative, is to develop custom report using Manage Controlled Processes from ACS Commons,

• https://adobe-consulting-services.github.io/acs-aem-commons/features/mcp/index.html
• https://adobe-consulting-services.github.io/acs-aem-commons/features/mcp/subpages/process-definition...

Sample report implementation you can find under:

• https://github.com/Adobe-Consulting-Services/acs-aem-commons/blob/master/bundle/src/main/java/com/ad...

This will give you an idea how you can start, if you would decide to create custom Process Definition to generate a report.