Procedure: nornix_site.find_document_path_elements

Information
DeterministicData accessMode
NOREADS SQL DATA

Code

Find pathparts for document

CREATE DEFINER=`root`@`localhost` PROCEDURE `find_document_path_elements`(IN vNo INTEGER)
    READS SQL DATA
    COMMENT 'Find pathparts for document'
BEGIN
 SELECT parent.No, parent.PathPart
 FROM document AS node, document AS parent
 WHERE node.Lft BETWEEN parent.Lft AND parent.Rgt
 AND node.No = vNo
 ORDER BY parent.Lft;
END