Hi aneeta45259594,Thanks for your help. It worked for me.

Hi All,I tried with the below queryselect par.[jcr:path] from [nt:folder] As par WHERE ISDESCENDANTNODE(par, "/content/dam/mycompany/catalog/part/120/051/591") AND par.[jcr:path] not in(select parent.[jcr:path] from [nt:folder] As parent Inner Join [nt:file] AS child ON ISCHILDNODE(child, parent)WHE...

Hi aneeta45259594 and bsloki,I tried the query given by you but it's not returning any results.My requirement is to find the image nodes which don't have product-details.png image rendition.The logic in your query is saying to return all the renditions other than product-details.png which will not g...

Hi All,I want to search for image nodes which don't have particular image rendition.For example.,Suppose I have a path as '/content/dam/mycompany/catalog/part'.I want to find the images which don't have product-details.png rendition under rendition folder.Can anyone please help me to get the SQL2 qu...