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.
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:unstructuredproperty=cq:isCancelledForChildrenproperty.value=true
SELECT * FROM [cq:Page] AS page WHERE page.[jcr:content/cq:isCancelledForChildren] = true and ISDESCENDANTNODE([/content/YOUR-SITE])