Skip to main content
Oct 18, 2021 3:20 PM UTC
Solved

Possible to generate list of content fragments that have variations without editing or opening them?

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? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
lukasz-m
lukasz-mAccepted solution
Community Advisor
Oct 23, 2021 5:50 PM UTC

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

2 replies

lukasz-m
Community Advisor
lukasz-mCommunity AdvisorAccepted solution
Community Advisor
Oct 23, 2021 5:50 PM UTC

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
Translate
Oct 25, 2021 2:56 PM UTC

Brilliant! Thank you @lukasz-m 

Translate