• How to find Path of each document using sql

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #50589  by jllort
 
The path should be already calculated in the database. There's a configuration parameter what keep the path in the database, the problem is that kind of feature have a poor performance, if you rename a folder, all the hierarchy must be removed and the performance might be really bad. That's why by default we have disabled and we suggest not going in this direction. The path should be in the table OKM_NODE_BASE

The configuration parameter is named "store.node.path" ( https://docs.openkm.com/kcenter/view/ok ... eters.html ), all the previous files will not have calculated the right path in the database, you should execute an script to update all the nodes.

Why do you need this kind of view, what is the purpose?

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.