Function: nornix_site.find_parent_path

Information
DTD identifier	Deterministic	Data access	Mode
varchar(128) CHARSET utf8	NO	READS SQL DATA

Code

Assembles the path of the parent document

CREATE DEFINER=`root`@`localhost` FUNCTION `find_parent_path`(vNo INTEGER) RETURNS varchar(128)
CHARSET utf8
    READS SQL DATA
    COMMENT 'Assembles the path of the parent document'
BEGIN
 DECLARE path VARCHAR(128);
 SELECT GROUP_CONCAT(p.PathPart ORDER BY p.Level ASC SEPARATOR '/') INTO path
 FROM document c, document p
 WHERE p.Level < c.Level
 AND p.Lft < c.Lft
 AND p.Rgt > c.Rgt
 AND (c.No = vNo);
 IF path = '' THEN
  RETURN '/';
 END IF;
 RETURN path;
END