topic Re: How to get the datalist from alfresco database? in Alfresco Forum

How to get the datalist from alfresco database?

cyrose22 — Tue, 10 Apr 2018 09:09:41 GMT

Hi All, We have this request to create a report to compare Alfresco Site's data VS. Our own System Data. And now what we aim is get the list of file names or data under sites then insert it to outside DB(Oracle or MySql), but the problem is we have no idea where to start yet. We are still on resear

Re: How to get the datalist from alfresco database?

calvo — Tue, 10 Apr 2018 10:57:36 GMT

Hi,

You could recover this information using CMIS, but anyway there are any other options.

Using the CMIS Workbench with Alfresco | Alfresco Documentation

Apache Chemistry - CMIS Workbench

Other option is using "Node Browser" (http://localhost:8080/alfresco/s/admin). You can execute a query on an specific space (in my case: 8878a6a9-c525-4180-9252-6c85bd2f6d43).

Regards,

clv

Re: How to get the datalist from alfresco database?

cyrose22 — Tue, 10 Apr 2018 23:55:06 GMT

Thank you sir

Re: How to get the datalist from alfresco database?

cyrose22 — Wed, 11 Apr 2018 09:03:40 GMT

Jose Angel Gonzalez Calvo‌ hi sir jose, can u teach me how to query all child name, child content inside that node?

im using this query to get to the folder, but after searching, it will go directly to cm:comments & fm: discussion all i need is to display all the pdf file

SELECT cmisbjectId,cmis:name,cmisath FROM cmis:folder WHERE CONTAINS('PATH:"//app:company_home/st:sites/cmims-metro-carmen/cm:documentLibrary/cmENZ50//*"')