Helpful AEM Queries
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"