How do you find all content fragment references?

[relaxabyte-corp]

Hello,

I would like to see all references of a variation of a content fragment. I did not see "References" in the metadata properties screen like other assets. I have been doing this by Query. Is there a tool that is available to do this that I missed? If not, is anyone aware of someone already building this (and what git repo would that be)?

Thanks,

relaxabyte

[Gaurav-Behl · Accepted solution]

Via UI, it is available irrespective of master/variation version, just select the CF on dam list page (http://localhost:4502/assets.html/content/dam)​ and click on Filter on left side

Via Query: you may follow this API. check the xhr tab

or try

"The Adobe AEM Quickstart and Web Application."

[relaxabyte-corp]

Thanks for the quick reply. I missed the Filter when looking for references. I am surprised that the ability to filter by variation hasn't come up.

I was using SQL2:

SELECT * FROM [nt:unstructured] AS comp
WHERE ISDESCENDANTNODE(comp, "[/content/parent/path]")
AND [sling:resourceType] = "dam/cfm/components/contentfragment"
AND comp.fileReference = "[content/dam/path/to/content/fragment]"

AND comp.variation = "[variationName]"

Is it possible to extend Site Reference to include a variation? It seems like that info could be available from the API.

[Gaurav-Behl]

Try this - ContentVariation ("The Adobe AEM Quickstart and Web Application.") 

package:

com.adobe.cq.dam.cfm ("The Adobe AEM Quickstart and Web Application.")