How to find whether particular image rendition exists or not using query debugger or SQL2 query?

[#1]

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 query or query using AEM query debugger?

Thanks,

Prajakta

[#2]

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 give the correct results.

Suppose one of the renditions folder has this rendition. Due to the above query, all the renditions other than product-details.png under that folder will be there in result which is not the requirement.

Thanks,

Prajakta