Node path which has cq:isCancelledForChildren as true...

[srinivas_chann1]

Hi,

I am using AEM6.3

Could some help me with an query on a particular page to get all the node paths that will show up for nodes having the property as cq:isCancelledForChildren": true  under a page

This i would to get details as which all nodes have inheritance broken.

Thanks

[aemmarc]

SELECT * FROM [cq:Page] AS page WHERE page.[jcr:content/cq:isCancelledForChildren] = true and ISDESCENDANTNODE([/content/YOUR-SITE])

[srinivas_chann1]

Hi Marc,

Thanks for the inputs .I want to know if we can find property anywhere under child nodes of any page  with have the property cq:isCancelledForChildren .When i applied the above query it is not fetching results I am assuming it looks only under jcr:content node

Thanks

[Vijayalakshmi_S · Accepted solution]

Hi,

Try the below in your instance querydebug console. (http://localhost:4502/libs/cq/search/content/querydebug.html)

path=/content/we-retail (your project content path)
type=nt:unstructured
property=cq:isCancelledForChildren
property.value=true