Customize the AEM ACS Commons Query Report Builder to run multiple queries based on the selection of a dropdown

[lone_Ranger]

Hi All,

I have a requirement to customize AEM ACS Commons Query Report Builder.
I have created dropdown Tier wise (Tier1, Tier2, Tier3) each tyre has Multiple paths.
Like Tier1 has 4 paths, Tier2 has 10 paths
on basis of selection i need to Execute query

I am using 

but in XML i can't write multiple queries

<queryconfig
jcr:primaryType="nt:unstructured"
sling:resourceType="acs-commons/components/utilities/report-builder/configs/queryconfig"
pageSize="50"
query="type=cq:Page&#xa;path={{parentPath}}&#xa;1_property=jcr:content/cq:template&#xa;1_property.value={{pageTypes}}&#xa;2_property=jcr:content/cq:lastReplicated&#xa;2_property.operation={{isPublished}}&#xa;3_property=jcr:content/jcr:primaryType&#xa;3_property.value=cq:PageContent"
queryLanguage="queryBuilder"
reportExecutor="com.adobe.acs.commons.reports.models.QueryReportExecutor"/>

Any Suggestions how to implement this.

Thanks in Advance.

[EstebanBustamante]

Hi,

I am not sure if I am understanding correctly what you are trying to do but I think you should use a report per query for better readability, but since this is ACS Commons, I suggest posting your question directly in their GitHub repository for better visibility: https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/configuring.html 

Hope this helps

[kautuk_sahni]

@lone_Ranger Did you find the suggestion helpful? Please let us know if you require more information. Otherwise, please mark the answer as correct for posterity. If you've discovered a solution yourself, we would appreciate it if you could share it with the community. Thank you!

[lone_Ranger · Accepted solution]

Correct ans - 

create your own query report 

in XML change the class name.

reportExecutor="com.adobe.acs.commons.reports.models.QueryReportExecutor to your class.

Thanks