cancel
Showing results for 
Search instead for 
Did you mean: 

getting all node properties through mysql query from Alfresco DB

kranthi
Star Contributor
Star Contributor

Hi all,

How we will get the all node properties through Mysql query from alfresco Database??.

Can we get all the details through mysql query ??

3 REPLIES 3

afaust
Legendary Innovator
Legendary Innovator

You can - simply do a select from the alf_node_properties table and restrict based on node_id.

Of course it is far easier and recommended to use the Alfresco APIs. That way you automatically get all the proper value type conversions, so you don't have to deal with it yourself.

kranthi
Star Contributor
Star Contributor

Yes your correct but I want to create the reports in Jboss Dash builder so for that I am trying to get the all details of Node using MySql query.

jpotts
World-Class Innovator
World-Class Innovator

Just be aware that the work could be wasted if Alfresco decides to change their schema, which they are free to do because the schema is not considered public.

Depending on how many reports are being run and how often, you are also putting the performance of the entire platform at risk.

A better approach would be to either enable auditing subsystem and report from those tables, which are public, or set up some behaviors that extract what you need using the public API and write it to streams, queues, or a database.