Page 1 of 1

Re: How to find Path of each document using sql

Posted: Sun Oct 04, 2020 6:51 am
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?