Expand my Community achievements bar.

SOLVED

Filtering results in a custom report

Avatar

Level 3

I am trying to configure a custom report that pulls pages from a path that should exclude some directories.

 

For ex:

I wanted everything under /content business except the below directories

/content/business/enterprise(Site A)

/content/business/support(Site B)

 

How can i configure the root path for the report? I tried using a regex but didn't seem to work. Also tried to add a property constraint on the querybuilder

to include only resourceType of Site A but i cannot include another value to it.

 

 N:propertyConstraints
    [
        N:<name> // array of nodes (name irrelevant), each with the following properties:
            P:name
            P:value
    ]

 

<!-- ... -->
    <jcr:content
        cq:designPath="/etc/designs/reports/userreport"
        jcr:primaryType="cq:PageContent"
        sling:resourceType="cq/reporting/components/reportpage">
        <report
            jcr:primaryType="nt:unstructured"
            rootPath="/home/users"
            sling:resourceType="cq/reporting/components/compreport/compreport"/>
    </jcr:content>
<!-- .. -->
1 Accepted Solution

Avatar

Correct answer by
Level 10

We gave wriiten many tools that search the JCR and dump out results. I find using a custom App with the JCR API and outputting the data to Excel works best. 

View solution in original post

3 Replies

Avatar

Level 10

Can you post the Querybuilder syntax you are using. 

Avatar

Correct answer by
Level 10

We gave wriiten many tools that search the JCR and dump out results. I find using a custom App with the JCR API and outputting the data to Excel works best. 

Avatar

Level 3

Thank you i decided to follow this path. Thanks for the suggestion.