Hi , To filter based on a property in the 2nd level of the parent node (sling:Folder), use the JOIN clause in your query: SELECT asset.[jcr:path] FROM [dam:Asset] AS assetJOIN [sling:Folder] AS folder ON ISCHILDNODE(asset, folder)WHERE ISDESCENDANTNODE(asset, [/content/dam/my-org/testdev25ex])AND fo...