Meta-data about a particular document in the repository

[jp]

I would ideally like to have the following information from the alfresco database:

1. what content belongs to a particular user (simple list of content names) - what is the table that stores this information

2. how do i get all the unique information about the meta data of a document that is stored in the repository - looking at the alf_node_properties table is not quite clear. Maybe a query that accomplish this task would be very helpful.

[pascalt]

Hi jp,

1. Concerning your first question, i don't think there is a special table that stores your personal content (please correct me if i'm wrong ).
But you can get your personal content items by issueing a lucene query on the cm:creator or cm:modifier property value with the specified username.

2. You can walktrough all the applied aspects and properties of a content reference in your code.

Hope this helps 

[jp]

thanks:-)