Hi guys
I want to build a view of documents which contains their name,uuid and path (my database is mysql 5.5)
I don't know why NBS_PATH is empty for each node at OKM_NDOE_BASE table and i think i have to build the path by myself based on the NBS_UUID and NBS_PARENT of each node.
I have written an stored procedure which find the path of each document based on its uuid but as i need a view , i cant use it.
Is there any way to build this view in mysql 5.5 ?
(im using openkm 6.3 community edition)
I want to build a view of documents which contains their name,uuid and path (my database is mysql 5.5)
I don't know why NBS_PATH is empty for each node at OKM_NDOE_BASE table and i think i have to build the path by myself based on the NBS_UUID and NBS_PARENT of each node.
I have written an stored procedure which find the path of each document based on its uuid but as i need a view , i cant use it.
Is there any way to build this view in mysql 5.5 ?
(im using openkm 6.3 community edition)