report on CF Models usage | Community
Skip to main content
sreenu539
sreenu539
New Participant
March 6, 2023
Solved

report on CF Models usage

  • March 6, 2023
  • 1 reply
  • 625 views

Hi

 

I need to generate a report on a cf model. 

All content fragments (cf) that using "simple fragment" as cf model.

 

Is it aem query debugger only the way to find out above or is there a screen in AEM that could provide this information , report?

 

Thanks,

Sri

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by lukasz-m

Hi @sreenu539 

In term of GUI option I would recommend to use Report Builder functionality from ACS Commons:

It is very flexible and simple to use tool. It allows to define report base on query, and generate results a a table that can be seen in AEM or download as csv file and reviewed offline on local computer.

Below is a sample configuration of report that will return list of links to CF build using Simple Fragment model.

  • configuration
  • result

I used following SQL2 query in my report:

SELECT * FROM [dam:Asset] AS s WHERE ISDESCENDANTNODE([/content/dam]) and s.[/jcr:content/model/jcr:title] = "Simple Fragment" and s.[/jcr:content/contentFragment] = true

You can also use Query option from crx/de to run query and get the result, but I would consider this more a like an for administrator or developer.

1 reply

lukasz-m
lukasz-mAccepted solution
New Participant
March 6, 2023

Hi @sreenu539 

In term of GUI option I would recommend to use Report Builder functionality from ACS Commons:

It is very flexible and simple to use tool. It allows to define report base on query, and generate results a a table that can be seen in AEM or download as csv file and reviewed offline on local computer.

Below is a sample configuration of report that will return list of links to CF build using Simple Fragment model.

  • configuration
  • result

I used following SQL2 query in my report:

SELECT * FROM [dam:Asset] AS s WHERE ISDESCENDANTNODE([/content/dam]) and s.[/jcr:content/model/jcr:title] = "Simple Fragment" and s.[/jcr:content/contentFragment] = true

You can also use Query option from crx/de to run query and get the result, but I would consider this more a like an for administrator or developer.

    Terms & ConditionsAccessibility statement

    Loading footer...