Filtering results in a custom report | Community
Skip to main content
New Participant
January 10, 2017
Solved

Filtering results in a custom report

  • January 10, 2017
  • 3 replies
  • 1134 views

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>
<!-- .. -->
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by smacdonald2008

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. 

3 replies

New Participant
January 10, 2017

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

smacdonald2008
smacdonald2008Accepted solution
New Participant
January 10, 2017

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. 

smacdonald2008
New Participant
January 10, 2017

Can you post the Querybuilder syntax you are using.