getting all node properties through mysql query from Alfresco DB

cancel
Showing results for 
Search instead for 
Did you mean: 
kranthi
Active Member II

getting all node properties through mysql query from Alfresco DB

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
afaust
Master

Re: getting all node properties through mysql query from Alfresco DB

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
Active Member II

Re: getting all node properties through mysql query from Alfresco DB

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
Professional

Re: getting all node properties through mysql query from Alfresco DB

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.