getting all node properties through mysql query from Alfresco DB

[kranthi]

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 ??

[afaust]

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]

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]

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.