Find out the nodes where the property exists and not empty. SELECT * FROM [nt:unstructured] as node WHERE ISDESCENDANTNODE(node, "/content/path-to-search") AND node.[propertyname] <> "" Search for all the nodes which are having a specific value SELECT * FROM [nt:unstructured] as node WHERE ISDESCENDANTNODE(node, "/content/path-to-search") AND node.[propertyName] = "property-value"
This blog provides information related to AEM features and customization of features in AEM. Very useful and will be helpful for learning and understanding AEM