Re: How to find Path of each document using sql
PostPosted:Sun Oct 04, 2020 6:51 am
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?
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?