How to find Path of each document using sql

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.
Post Reply
jllort
Moderator
Moderator
Posts: 11474
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: How to find Path of each document using sql

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