Hi Arun. Hoping to pick your brain again as I didn't get very far with your last tip. I tried running the following query thinking I'd be able to see the text property values: SELECT child.*, ann.* FROM [nt:unstructured] AS child INNER JOIN [nt:unstructured] AS ann ON ISDESCENDANTNODE(ann,child) WHE...

Yay... I see it now. Thanks very much for all your help!

ah.. ok. thanks. that worked. now I see the path in my results. would you mind pointing me to the relevant table(s) with the annotation text? happy to read thru any reference material freely available (c: and if I was to list out all the tables, is there a generic name to use for the database name?

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 node...

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 especi...