Solved

exporting annotations

Forum|Forum|5 years ago
February 3, 2021
1 reply
2107 views

hello. is it possible to export annotations from pages in AEM? and if so, how?

to keep track of comments, we'd like to include them in a table or spreadsheet. so far, it is possible to manually click on each annotation to copy and paste the comments into Excel. however, this is time consuming especially for files with more than 50 annotations.

thanks in advance for any thoughts or guidance on a more automated method.

kindest regards,

baz

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 arunpatidar

Hi,

The annotation saved in the page tree, a speacial node cq:annotations contains all the annotations, you can simply query this node using querybuilder and get only text or whichever property you want in a json format and convert into csv using simple javascript.

arunpatidar

Accepted solution

Community Advisor

Hi,

The annotation saved in the page tree, a speacial node cq:annotations contains all the annotations, you can simply query this node using querybuilder and get only text or whichever property you want in a json format and convert into csv using simple javascript.

Arun Patidar

B

bazzzAuthor

Hi Arun. Thank you for your response. I found the node, but I'm having trouble querying it. We have CRXDE Lite. I'm getting the following message when running a simple query (select * from nt:base where jcr:path like '/content/...%') from nt:base >> "The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped." Would you be able to recommend a good reference to learn more about this environment and how to interrogate it with query builder? NB: I'm a front-end user so I'm unsure if that's also part of the problem!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded