Function: nornix_site.find_doc_path

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

Code

Assembles the path of a document

CREATE DEFINER=`root`@`localhost` FUNCTION `find_doc_path`(vNo INTEGER) RETURNS varchar(128) CHARSET
utf8
    READS SQL DATA
    COMMENT 'Assembles the path of a 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