Hi All,
Is there any way to write a query and find the assets which are not having any renditions.
Thanks,
Selva
Solved! Go to Solution.
Generally for any dam asset rendition are existed under jcr:content node.
/content/dam/XXXX/global/Images/inline_images/gx_hc_aging2.jpg/jcr:content/renditions
You can validate if there are any node is existed with redntions node then you can say rendtions are existed.
I have provided more of theory ,you can frame SQL query.
Thanks,
Kishore
Generally for any dam asset rendition are existed under jcr:content node.
/content/dam/XXXX/global/Images/inline_images/gx_hc_aging2.jpg/jcr:content/renditions
You can validate if there are any node is existed with redntions node then you can say rendtions are existed.
I have provided more of theory ,you can frame SQL query.
Thanks,
Kishore
Hi
Can you please look at the answer posted and let us know if this worked for you or not.
If you have devised another way to resolve the issue, please post it in the community for communities benefit.
Thanks and Regards
Kautuk Sahni
Views
Replies
Total Likes
Can anyone provide more detail on the solution? Example, I'm trying to test an SQL query using the CRXDE query tool:
SELECT * FROM [dam:Asset] AS s
WHERE ISDESCENDANTNODE(s,[/content/dam/bla/])
AND [s].[jcr:content/renditions/cq5dam.web.1280.1280.png/jcr:createdBy] IS NULL
This spins for a bit and throws "Query execution resulted in an error!". I tried pulling up DEBUG logs for the query and I don't see any error in the logs.
I also tried variations, example:
AND [s].[jcr:content/renditions/cq5dam.web.1280.1280.png] IS NULL
also gives an error. I verify that the nodes I'm looking for do exist in CRX. Just to prove I know what I'm doing I can successfully run:
SELECT * FROM [dam:Asset] AS s WHERE ISDESCENDANTNODE(s,[/content/dam/bla/])
AND [s].[jcr:content/metadata/property_im_checking] IS NOT NULL
...and that works every time.
Views
Replies
Total Likes
Views
Likes
Replies