Procedure: nornix_site.find_child_docs

Information
DeterministicData accessMode
NOREADS SQL DATA

Code

Find child documents of document

CREATE DEFINER=`root`@`localhost` PROCEDURE `find_child_docs`(IN vNo INTEGER)
    READS SQL DATA
    COMMENT 'Find child documents of document'
BEGIN
 DECLARE l, r , levl INTEGER;
 SELECT Lft, Rgt, (`Level` + 1) INTO l, r, levl FROM document WHERE `No` = vNo;
 SELECT *
 FROM document
 WHERE `Level` = levl AND Lft > l AND Rgt < r
 ORDER BY Lft;
END