'Comments', where are they stored and how to retrieve them

[bisana]

Hi
I am using alfresco 4.0.d, I have got a fair idea of how share works.
I am now interested in the information which  a user can enter in comment fields.
It can happen that as time goes on lots of comments are added, and at one point the user wants a list of all the comments, and is there any options to do this. I am thinking this as a feature
I would like to know where is the comments field stored?
Guidance requested
Thanks
Joseph John

[arnoldschrijve1]

Well, the comments of a single node can be queried easily using the repository webscript /api/node/{store_type}/{store_id}/{id}/comments defined in alfresco/templates/webscripts/org/alfresco/repository/comments.

In comments.get.js and comments.lib.js you can see that the comments are associated to a node by adding the fm:discussable aspect to it. This has an association to fm:discussion which contains the comments folder.

If you want to aggregate comments across multiple nodes you`ll probably have to roll your own script here. You could make use of the search service to retrieve all nodes with comments.