Filtering results in a custom report

[sanjays16398239]

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>

<!-- .. -->

[smacdonald2008]

Can you post the Querybuilder syntax you are using. 

[smacdonald2008 · Accepted solution]

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. 

[sanjays16398239]

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