Combine Multiple ACS Commons Report to One Report | Community
Skip to main content
aemUser2345
Level 3
Apr 12, 2023 10:18 PM UTC
Solved

Combine Multiple ACS Commons Report to One Report

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
lukasz-m
lukasz-mAccepted solution
New Participant
Apr 16, 2023 7:23 PM UTC

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.

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,

Sample report implementation you can find under:

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

View reply

1 reply

lukasz-m
lukasz-mAccepted solution
New Participant
Apr 16, 2023 7:23 PM UTC

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.

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,

Sample report implementation you can find under:

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

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...