topic alfresco database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-database/m-p/281335#M234465 <HTML><HEAD></HEAD><BODY><SPAN>Hi!</SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>i read that theses infos are store in alf_node, alf_node_properties, alf_store tables</SPAN><BR /><BR /><SPAN>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';</SPAN><BR /><BR /><SPAN>Any help is very welcome!</SPAN><BR /><SPAN>thx</SPAN><BR /><BR /></BODY></HTML> Tue, 01 Apr 2014 16:16:42 GMT cyr 2014-04-01T16:16:42Z alfresco database https://connect.hyland.com/t5/alfresco-archive/alfresco-database/m-p/281335#M234465 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 tablesSELECT * FROM alf_node_properties AS np JOIN alf_node AS n ON np.nod Tue, 01 Apr 2014 16:16:42 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-database/m-p/281335#M234465 cyr 2014-04-01T16:16:42Z Re: alfresco database https://connect.hyland.com/t5/alfresco-archive/alfresco-database/m-p/281336#M234466 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>Jeff</SPAN></BODY></HTML> Tue, 01 Apr 2014 16:18:28 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-database/m-p/281336#M234466 jpotts 2014-04-01T16:18:28Z