AnsweredAssumed Answered

alfresco database

Question asked by cyr on Apr 1, 2014
Latest reply on Apr 1, 2014 by jpotts
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

Outcomes