print_user_request_parameter

Parameters

Name	Type
all_col	BOOLEAN
var_table	VARCHAR(50)
cel_table	VARCHAR(50)

SQL Definition

CREATE PROCEDURE `print_user_request_parameter`(IN all_col BOOLEAN, IN var_table VARCHAR(50), IN cel_table VARCHAR(50))
BEGIN
    IF all_col THEN
    		SET @stmt = CONCAT("SELECT va.ind, va.var_name, 
           (SELECT GROUP_CONCAT(ce.cost_element SEPARATOR ', ')
            FROM ", cel_table, " ce
            WHERE FIND_IN_SET(va.var_name, REPLACE(ce.variables, ' ', '')) > 0) AS ce_affected
    		FROM ",var_table," as va
    		WHERE va.var_value IS NULL
    		ORDER BY va.ind;");
        ELSE
            SET @stmt = CONCAT("SELECT va.var_name, 
           (SELECT GROUP_CONCAT(ce.cost_element SEPARATOR ', ')
            FROM ", cel_table, " ce
            WHERE FIND_IN_SET(va.var_name, REPLACE(ce.variables, ' ', '')) > 0) AS ce_affected
    		FROM ",var_table," as va
    		WHERE va.var_value IS NULL
    		ORDER BY va.ind;");
        END IF;
        PREPARE stmt FROM @stmt;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
END;;