How to report on "annotations"?

[ncw3qwp]

Is it possible to extract the annotation data (attributes and values) using the ACS AEM Commons "Reports" functionality?

I'm trying to find the "annotations" node in CRXDE Lite, but can't find it.

[lukasz-m · Accepted solution]

Hi @ncw3qwp,

Yes this is possible to get annotation data using Reports from ACS Commons. Here is an example, for below crx structure

.

• Report configuration, I have used following SQL query to get the data:
  

  SELECT child.* FROM [nt:base] AS parent INNER JOIN [nt:base] AS child ON ISCHILDNODE(child, parent) WHERE ISDESCENDANTNODE(parent, "{{path}}") AND name(parent) = "cq:annotations"

  where {{path}} is variable to pass content path to query to generate the report.
  
  Above screen shows which component has been used to build the report and, what exact values each component contains.
• Sample result - to be clear I have added 2 annotation on page from we-retail for testing purposes
  

[ncw3qwp]

@lukasz-m this helped. Thank you!