Trying to avoid having to verify one at a time which content fragments currently have variations within them. I have tried performing various queries but no luck. Any ideas?
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @brianlplfinancial, you can try to run below SQL2 query
SELECT * FROM [dam:Asset] AS cf WHERE ISDESCENDANTNODE([/content/dam]) AND cf.[jcr:content/contentFragment] = true AND cf.[jcr:content/model/variations/jcr:primaryType] IS NOT NULL
Hi @brianlplfinancial, you can try to run below SQL2 query
SELECT * FROM [dam:Asset] AS cf WHERE ISDESCENDANTNODE([/content/dam]) AND cf.[jcr:content/contentFragment] = true AND cf.[jcr:content/model/variations/jcr:primaryType] IS NOT NULL
Brilliant! Thank you @lukasz-m
Views
Replies
Total Likes