Procedure: nornix_site.get_properties_raw

Information
DeterministicData accessMode
NOREADS SQL DATA

Code

Loads raw properties according to document number sent

CREATE DEFINER=`root`@`localhost` PROCEDURE `get_properties_raw`(IN vDocNo INTEGER)
    READS SQL DATA
    COMMENT 'Loads raw properties according to document number sent'
BEGIN
 SELECT *
 FROM property prop
 WHERE prop.DocumentNo=vDocNo
 ORDER BY prop.Class ASC, prop.Attribute ASC;
END