alfresco database

[cyr]

Hi!
I want to retrieve the name of documents and folders stored in alfresco database, i've written the following request but i don't see those name.
i read that theses infos are store in alf_node, alf_node_properties, alf_store tables

SELECT * FROM alf_node_properties AS np JOIN alf_node AS n ON np.node_id=n.id JOIN alf_store AS s ON n.store_id = s.id WHERE s.protocol='workspace' AND s.identifier='SpacesStore' AND n.audit_creator!='System';

Any help is very welcome!
thx

[jpotts]

You should not be querying the Alfresco tables directly. Instead, to get document and folder names, use OpenCMIS, which is the preferred API for working with Alfresco if you are not running in the same process. If your code is running in the same process, use the Java API.

Jeff