Display procedure output in dialog

App Building
1

Is it possible to show the output print of a called procedure on retool. My procedure works perfectly but instead of showing the else print it just says run successfully .

2

Hey @jakinda1,

I'm assuming that by procedure you mean Query? Do you return the data you want in your query? Could you share your query?

3

hi @minijohn

DELIMITER $$

CREATE PROCEDURE GetCustomerLevel(
    IN  pCustomerNumber INT, 
    OUT pCustomerLevel  VARCHAR(20))
BEGIN
    DECLARE credit DECIMAL DEFAULT 0;

    SELECT creditLimit 
    INTO credit
    FROM customers
    WHERE customerNumber = pCustomerNumber;

    IF credit > 50000 THEN
        SET pCustomerLevel = 'PLATINUM';
        SELECT pCustomerLevel ;
    ELSE
        SET pCustomerLevel = 'NOT PLATINUM';
        SELECT pCustomerLevel ;
    END IF;
END$$

DELIMITER ;

I want to after print pCustomer level on retool, as a popup after running procedure. Procedure is on workbench am calling it on retool

4

@jakinda1

Hey there :wave: You should be able to create an event handler for this query that opens up a modal with the pCustomer level

898×812 177 KB

1 Like