ACS Common Report Tool | Community
Skip to main content
tushaar_srivastava
tushaar_srivastava
Level 6
January 12, 2023
Solved

ACS Common Report Tool

  • January 12, 2023
  • 1 reply
  • 908 views

Hi All,
I have a requirement where I need get the report of all the page which is under let say /content/project/websites/en-us/ and having template /conf/testing/settings/wcm/templates/wrapper-template and the value of content propery: 
example :

Now fetch all the pages with particular template and get the property value of content which is String[] under /content/project/website/en-us/test1/jcr:content/root/container/wrapper

 

 

I tried to do this using ACS Common Report tool where I wrote a query

SELECT * FROM [cq:Page] AS nodes WHERE (isdescendantnode('{{path}}')) AND nodes.[jcr:content/cq:template]='/conf/testing/settings/wcm/templates/wrapper-template' AND (nodes.[jcr:content/root/container/wrapper] ='' OR nodes.[jcr:content/root/container/wrapper] IS NULL )

 

Can anyone please help here to correct me the query to get the property of string[] of content. because using this I am not able to get the multiple value of property inder /jcr:content/root/container/wrapper [content[]]

 

 

Thanks 

 

@kautuk_sahni  @arunpatidar  @briankasingli 

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 arunpatidar

Hi,

You need to write a joined query

Example

SELECT child FROM [cq:Page] AS parent INNER JOIN [nt:unstructured] AS child ON ISCHILDNODE(child,parent) WHERE ISDESCENDANTNODE(parent, '{{path}}') AND parent.[jcr:content/cq:template]='/conf/testing/settings/wcm/templates/wrapper-template' AND child.[sling:resourceType] = 'migration/components/wrapper'

 

1 reply

arunpatidar
Community Advisor
arunpatidarCommunity AdvisorAccepted solution
Community Advisor
January 12, 2023

Hi,

You need to write a joined query

Example

SELECT child FROM [cq:Page] AS parent INNER JOIN [nt:unstructured] AS child ON ISCHILDNODE(child,parent) WHERE ISDESCENDANTNODE(parent, '{{path}}') AND parent.[jcr:content/cq:template]='/conf/testing/settings/wcm/templates/wrapper-template' AND child.[sling:resourceType] = 'migration/components/wrapper'

 

Arun Patidar
    tushaar_srivastava
    tushaar_srivastavaAuthor
    Level 6
    January 13, 2023

    Thank you @arunpatidar   this really helped me, and the issue was I need to read the multi value of a property content which is under node jcr:content/root/container/wrapper, I was passing Property payload wrong in report tool It was passing /jcr:content/root/container/wrapper instead of: 

     

     

      Terms & ConditionsAccessibility statement

      Loading footer...