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 ??
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.
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.
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.
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.