Filtering results in a custom report | Community
Skip to main content
Level 2
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

smacdonald2008
Level 10
January 10, 2017

Can you post the Querybuilder syntax you are using. 

smacdonald2008
smacdonald2008Accepted solution
Level 10
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. 

Level 2
January 10, 2017

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